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...
 
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

Need to compare 2 tables and only pull certain records from one ta 3
Have both records from two queries/tables under one Query without related fields. 0
State abbreviation MI fails in query 2
Query Quandry 6
Query is returning several records 4
Query Field Using Other Fields in the Query 3
Append Query and Combo Lookup Problems 1
criteria on form 1

Back
Top