Query on a string of calculations?

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

Guest

I'm adding up a number of fields to obtain one value, and adding up another
group of fields to obtain another value. I then calculate a third field by
subtracting one of those values from the other, and if the absolute
difference is greater than X, then further action is indicated for the record.

So to create a report of those records requiring further action, do I have
to redo all the calculations that are happening in the form since none of the
results are being stored in a table?

tia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations..subtracting Minutes 3
Calculating averages on a form 3
Calculated field in a table 6
What makes a query updateable? 1
How do I calculate and store results? 3
Calculate Values in a table 2
If query/subform is empty set calculation value to 0 4
Calculated Controls Nz IIf 7

Back
Top