Sum returning double the result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 queries one that sorts and sums values by date(DayQuery), and
another that uses the 1st querie and then sums by area(AreaQuery). It works
properally expect when the date has 2 enteries for one area. The Sum is
always double the value.
 
Jenna said:
I have 2 queries one that sorts and sums values by date(DayQuery), and
another that uses the 1st querie and then sums by area(AreaQuery). It
works
properally expect when the date has 2 enteries for one area. The Sum is
always double the value.
Click to expand...

Can you print the SQL code for your two queries here?

Carl Rapson
 
Thanks for taking the time to answer my post. I figured out the problem
already it was just an issue with my query set up.
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here. Information on primary keys and relationships
would be a nice touch too.
 
I have 2 queries one that sorts and sums values by date(DayQuery), and
another that uses the 1st querie and then sums by area(AreaQuery). It works
properally expect when the date has 2 enteries for one area. The Sum is
always double the value.
Click to expand...

Please open the queries in SQL view and post the SQL text here. My guess is
that you have an invalid join so that the same record is being returned twice,
but that's only a guess without being able to see the query!

John W. Vinson [MVP]
 
Back
Top