Calculations from two different Records?

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

Guest

How can I pull data from two different records and two different fields and
perform calculation? For example, pull data from one record that was inputed
to a table on Monday and pull data from a different field that was inputed on
Friday.
 
hi,
you will need 2 queries. 1 query pulling the monday data
which should only produce only 1 record.
put the 1st query in the second query along with the
table. draw the 2nd data bit from the table and the
results of the 1st query. do the calculation in the 2nd
query.
 
Thanks for the Help. Works fine.

[email protected] said:
hi,
you will need 2 queries. 1 query pulling the monday data
which should only produce only 1 record.
put the 1st query in the second query along with the
table. draw the 2nd data bit from the table and the
results of the 1st query. do the calculation in the 2nd
query.
Click to expand...
 
Back
Top