calculations using queries

[Guest]

i was using the record source in my forms to do my calculations but the final
value will not work in my reports.... so i figured that a querie would be
the way to get the final values i need and alow me to use them in my reports
also... I am vary new to the use of queries and i also just upgraded to
access 2007, can someone tell me how to setup a querie do do the calcs from
several fields in a single form and single table... such as field1 +
field2 * field3 = total value so i can just link the querie to my form and
reports right? Thanks all!!

 

[Guest]

In your query you can create a field called TotalValue. It could look
something like this:

TotalValue:[field1]+[field2]+[field3]

The TotalValue will show up as the columnheader. You can type anything there
you like.

hth