2 query and 1 one for total

A

a

Thank you
Query 1 (avilable)
ID from to RN NN
Total company
1 1/1/2004 6/1/2004 10 5
50 TFT
1 2/1/2004 6/1/2004 10 5
50 TFT
1 3/1/2004 6/1/2004 10 5
50 TFT
1 4/1/2004 6/1/2004 10 5
50 TFT
1 5/1/2004 6/1/2004 10 5
50 TFT
1 6/1/2004 6/1/2004 10 5
50 TFT
Query 2 (Reservation)
ID from to RN NN
Total company
1 1/1/2004 3/1/2004 2 5 10
TFT
1 2/1/2004 3/1/2004 2 5 10
TFT
1 3/1/2004 3/1/2004 2 5 10
TFT
THE QUESTION:
The Result Should be Like Query 3
Query 3 (subtract) the result should be like this (the query I need to
perform)
ID from to RN NN
Total company
1 1/1/2004 6/1/2004 8 5
40 TFT
1 2/1/2004 6/1/2004 8 5
40 TFT
1 3/1/2004 6/1/2004 8 5
40 TFT
1 4/1/2004 6/1/2004 10 5
50 TFT
1 5/1/2004 6/1/2004 10 5
50 TFT
1 6/1/2004 6/1/2004 10 5
50 TFT
Plase Read This Notes:
1- Query 3 RN = (Query1 [Rn])-(Query2 [RN]) THIS IS ONLY THE Math Operation
in query3
2- You Shoud only subtract Query 3 RN = (Query1 [Rn])-(Query2 [RN]) if they
have the same date (FROM) only.
3- If You Find Dates Notes Matched put it as is like 4,5,6/1 Query1
4- Need More Information Please tell me ,Not understand the question Please
tell me.
 
Top