homepage Welcome to WebmasterWorld Guest from 54.227.215.140
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Doubled query result value
the value resulting from another table is doubled when i run the query
Squall2012



 
Msg#: 4518043 posted 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.

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved