Cross Tab Queries

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

Guest

Would somebody be able to tell me why my cross tab query
shows a wrong total for one of the categories I use?

I have broken down sales per product category for all this
year's months but in just one of the categories the
figures tote up with an error, duplicating one or two
values. The database which is the source of the data is
100 pct correct since when I print a report based on it
the totals add up correctly, but not so in the cross tab
query. Any suggestion?
 
Perhaps you could post the SQL for your crosstab query, and tell us which is
misbehaving?

- Turtle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing possibly blank Cross Tab in a query 3
Cross Tab Quert Totals 4
Ordering of Cross Tab Query 7
Creating a specific form 8
Basing a report on an updated cross-tab query 2
Append Query 3
"Rolling" quarterly average 3
Cross Tab Report Vs Dynamic coulmns 0

Back
Top