How do I add calculated field to a query

darrrellx

Registered User.
Local time
Yesterday, 18:54
Joined
Apr 25, 2005
Messages
22
I have an inventory transaction file that has quantity on hand as a calculated field. I am trying to add this unbound field to a report using a query but I can't figure out how to add my quantity on hand field to the query since it is a calculated field and not a bound control.

Any help would be appreciated.

Thanks

darrrellx
 
Quantity on hand sounds like it is a sum of other transactions. If the report is showing detail transactions, add a control to the report footer to sum the quantity fields:

=Sum(Quantity)


To add a calculated field to a query, switch to SQL view so you'll have more room -

Select fld1, fld2, fld3, fld4 + fld5 As calcFld6, fld7, fld8
From .....
 

Users who are viewing this thread

Back
Top Bottom