| Doubled query result value
the value resulting from another table is doubled when i run the query |
Squall2012
msg:4518045 | 3:14 pm on Nov 11, 2012 (gmt 0) |
Good day!
I'm having trouble using a query (select, make, cross tab, etc.)in access 2007 database. I already have three query tables having a common field/column as "TOTAL OUTPUT". When I make another query to display the three "TOTAL OUTPUT" from three different queries, I get the wrong answer and it doubles the value of these three "TOTAL OUTPUT".
To illustrate:
Query1:
Name=Q1
Category=1
T_Output=416
Date=10/1
Category=2
T_Output=521
Date=10/1
Query2:
Name=Q2
Category=1
T_Output=484
Date=10/1
Category=2
T_Output=1185
Date=10/1
Query3:
Name=Q3
Category=1
T_Output=660
Date=10/1
Category=2
T_Output=1008
Date=10/1
Using a 4th query to display these three outputs, i get:
Date : 10/1
Category : 1
Q1.t_output : 832
Q2.t_output : 968
Q3.t_output : 1320
Date : 10/1
Category : 2
Q1.t_output : 1042
Q2.t_output : 2370
Q3.t_output : 2016
The 4th query should display the same value from the source query in order to get the the accurate answer. Please help me on this matter.
Your suggestions and answers are highly appreciated.
Thank you very much.
|
|
