Calculate a Field Value in Access - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 03-31-2005, 11:05 AM   #1 (permalink)
Monster Techie
Join Date: Apr 2004
Posts: 1,574
Default Calculate a Field Value in Access

I have this Access database, and I want the contents of a particular field to consist of a calculation using values from another table.

I have table1, which contains the field with the calculation.
Table2, contains one of the fields containing the data to be calculated.
Table3, contains the other field with data to be calculated.

So I want a field in table1 to be the value in the field in table2 multiplied by the value in the field in table3.

Does anyone know how to do this? I'm guessing I need to enter some kind of special equation in the field in table 1?

Hope that makes sense!

Thanks in advance.

\'There is only one basic human right, and that is to do as you **** well please.
And with it comes the only basic human duty, to take the consequences.\'

m3trj is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:20 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.