Calculations in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which takes four numbers calculated using the summary function common to all queries, I use the summary function to accumulate the many different entries but this makes it very difficult to perform calculations. To perform my required calculation I have made a form with the information from the query, from this I perform my calculation. This works perfectly but for one of my forms I would like only items where the calculated number is 0 to be shown and not those where the calculated number is any number other than 0. I have attempted to calculate this in a query but the only way this could be done would be to not use the summary functions but as there are multiple entries this need to be used. So how is it possible to only see items with a quantity of 0? Any help would be much appreciated
 
WHERE field = 0

would be the typical syntax, but in your case, it may not work, due to the
multiple calculations that are occuring. You may need a seperate query, or
even a Dlookup() to assist you with the displaying the value on the form.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Flic said:
I have a query which takes four numbers calculated using the summary
Click to expand...
function common to all queries, I use the summary function to accumulate the
many different entries but this makes it very difficult to perform
calculations. To perform my required calculation I have made a form with the
information from the query, from this I perform my calculation. This works
perfectly but for one of my forms I would like only items where the
calculated number is 0 to be shown and not those where the calculated number
is any number other than 0. I have attempted to calculate this in a query
but the only way this could be done would be to not use the summary
functions but as there are multiple entries this need to be used. So how is
it possible to only see items with a quantity of 0? Any help would be much
appreciated
 
Back
Top