Cross Tab Queries

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?
 
M

MacDermott

Perhaps you could post the SQL for your crosstab query, and tell us which is
misbehaving?

- Turtle
 
Top