M
MichaelR
Hi,
I'm having a lot of trouble with a query that I wrote in access. This is the
first query that I've written so please forgive me if this question seems
obvious.
I have a table with sales data for 2006, 2007 and 2008 that has 49 columns
(some of which have data for all rows, some of which have data for some rows
only, and others that have no data in them).
My query summarizes the data by taking only a few of the 49 columns and also
by adding two calculated fields (one that calculates the geography and the
other that calculates whether the data represents actual or budgeted sales).
The two calculated fields work fine and I don't think that they're the
problem.
When I run the query, I only get 211,352 rows of data but the original sales
table has 330,663. I suspect that some of the rows get grouped together but I
don't think that alone explains the 120,000 row difference because the
combined table only has entries for 23 of the 69 sales reps that have sales
entries in the sales data table.
Any ideas why this might be happening or what steps I could take to figure
out the cause of the problem?
Many thanks in advance,
Michael
I'm having a lot of trouble with a query that I wrote in access. This is the
first query that I've written so please forgive me if this question seems
obvious.
I have a table with sales data for 2006, 2007 and 2008 that has 49 columns
(some of which have data for all rows, some of which have data for some rows
only, and others that have no data in them).
My query summarizes the data by taking only a few of the 49 columns and also
by adding two calculated fields (one that calculates the geography and the
other that calculates whether the data represents actual or budgeted sales).
The two calculated fields work fine and I don't think that they're the
problem.
When I run the query, I only get 211,352 rows of data but the original sales
table has 330,663. I suspect that some of the rows get grouped together but I
don't think that alone explains the 120,000 row difference because the
combined table only has entries for 23 of the 69 sales reps that have sales
entries in the sales data table.
Any ideas why this might be happening or what steps I could take to figure
out the cause of the problem?
Many thanks in advance,
Michael