C
conyers_roger
Hi all, I apologize if my question sounds rather simplistic, but I bet
many novices have encountered similar problems.
I'm trying to query a database table that approximately resembles
the following:
PRODUCT UNITS SOLD REGION YEAR
X 100 West 2001
X 25 South 2001
Y 50 South 2002
Z 150 North 2001
Is there a way I can create a query that summarizes the units of each
product sold on a yearly bases? i.e. for the above table that would be
125 units of Product X sold in 2001.
I tried the query's Total function and tried to use the Sum function
for various fields, but was not able to get the correct results.
Somehow, the query resuses to total the number of products sold for a
particular year. It just ends up summing up the years--for example, if
year 2001 occurs twice, it shows it as 4002--which is meaningless. Do
I have to insert a new column/field and try another formula, like DSUM?
When I created a cross-tab query, it was able to perform the summary,
but I was not able to do it in a regular query. Is there a formula
that would help me perform the calculation in a non cross-tab query?
Any response will be appreciated.
Roger
many novices have encountered similar problems.
I'm trying to query a database table that approximately resembles
the following:
PRODUCT UNITS SOLD REGION YEAR
X 100 West 2001
X 25 South 2001
Y 50 South 2002
Z 150 North 2001
Is there a way I can create a query that summarizes the units of each
product sold on a yearly bases? i.e. for the above table that would be
125 units of Product X sold in 2001.
I tried the query's Total function and tried to use the Sum function
for various fields, but was not able to get the correct results.
Somehow, the query resuses to total the number of products sold for a
particular year. It just ends up summing up the years--for example, if
year 2001 occurs twice, it shows it as 4002--which is meaningless. Do
I have to insert a new column/field and try another formula, like DSUM?
When I created a cross-tab query, it was able to perform the summary,
but I was not able to do it in a regular query. Is there a formula
that would help me perform the calculation in a non cross-tab query?
Any response will be appreciated.
Roger