HI,<br><br>I have one query that calculates the total of POs in one table, and another query to find the total of delivered pos, by looking it the field "status" for the criteria "DELIVERED". Now, I wanna a report that gets the total of POS ans subtract the total of delivered, so I can find the total exeptions, but since the results of total pos and total delivered are on different queries, how to get the report to look it up on both of them? Or how to simply make ONE query to find Total of POS ( which is actually the total of records on the table) and the total of DElivered ( everytime a PO gets deliverd, we tag it in the table field " statuts" to "DELIVEREd".
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW TO GET A REPORT TO USE DATA FROM 2 QUERIES
- Thread starter HerickP
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question