CrossTab Queries

  • Thread starter Thread starter Alec
  • Start date Start date
A

Alec

I have built a cross tab Query to show monthly sales for
my company grouped by product category. In just one of the
groups the query doesn't tote up correctly, sales shown
are in excess of actual sales by the exact amount of one
of the invoices included in the database. So when making a
report based on this corss tab query results shown are the
wrong ones. The table upon which the data are based is
correct, though, because when printing a report based on
this base table everything is correct. Can anyone give me
a hint as to what might be happening? Thanks
 
How many tables are involved in this query?

I'm guessing that the amount that is duplicated actually shows up in two
rows of the query. It would do that if you had something like a table of
Payments, and that particluar record was paid in two parts, so that the
amount showed on two rows.
 
Back
Top