Counting over a date range for different items.

[ADWoods]

Hi,

I am trying to create a report that will allow me to count the number of items logged in to my database per month. Then do another count for each item in the month. For example I have 6 items.

I have tried to create separate queries for each item I want to see and then merge them in another query with a date range (Between function).

When I use separate queries I get all items logged in to the database, as well as all products. It seems that queries in the merge query does not pickup the date range. Does any one know a way of getting this to work? Or is there an easier way to do this?

Thanks, ADWoods.

 

[fredk]

I probably need more information to help you but I will try to give you some feedback with what you have given.

I believe what you are saying is that you want to count the number of "x" for each of your six items monthly.

If I understand you correctly, you have a field with items - I will call the field "Item" Your query will need at least three fields; The "item" field, the date field (where you are going to use the criteria of "between 1/1/03 and 1/31/03" and a field to actually use to count. Make sure you select "totals" for the query....Under the field that you are counting you would make sure to select "count" under the total ...

Then create the report based on this query and you can add totals in the report footer.

Let me know if this does not work for you.

Fred

 

[ADWoods]

Hi Fred,

I have been able to create the report from the queries as you suggested and it now works. Thanks for your advice!!

ADWoods.