I'm not real swift at Access, which will be obvious!
I have a data base of items, some items are categorized as Ancient and some are categorized as Spanish.
Each item in the table is unique so there are only one of each item.
I am trying to create a year end query where I can total the cost of each category and know the count of how many is in each category.
The way I'm trying to do this is to create a column in the query that counts the number of items selected from the table in the query itself.
I have tried using DSum and Count, but when I use count I get the total of how many of the item selected in that row and not the total of all the rows in the query;
so count returns 1 in each case.
DSum I have not totally figured out the syntax even though I have read up on several sites.
It is not clear to me how to enter it.
Can anyone show me an example of a query that counts the number of items selected by the query itself?
I have a data base of items, some items are categorized as Ancient and some are categorized as Spanish.
Each item in the table is unique so there are only one of each item.
I am trying to create a year end query where I can total the cost of each category and know the count of how many is in each category.
The way I'm trying to do this is to create a column in the query that counts the number of items selected from the table in the query itself.
I have tried using DSum and Count, but when I use count I get the total of how many of the item selected in that row and not the total of all the rows in the query;
so count returns 1 in each case.
DSum I have not totally figured out the syntax even though I have read up on several sites.
It is not clear to me how to enter it.
Can anyone show me an example of a query that counts the number of items selected by the query itself?