I have a series of information that I would like to be able to essentially count occurrences of a specific item, within a date range.
I have a database that contains columns for DATE, Quantity, and Model number, there is other information gathered but these are the ones I'm working with currently.
I can use the query wizard to create a simple query. If I select model, and quantity, then select next it asks if I want a detailed or a summary. I choose summary and from the summary options I can choose SUM of quantity.
This gives me a very simple result with 2 columns, a model number and a total quantity. This works perfectly, exactly the way I want it to. Now, to add the date range function.
The only way I can get it to prompt for a date range is to add the date column to the query, choose unique day and time, and then put Between [Start Date] And [End Date] in the criteria of the date field. This is all well and good, it prompts me beautifully for a start and end date, but the totals it returns are then broken apart by specific day which I don't want. All I need the date range to do is narrow down the query, not do any grouping, etc.
I feel like it should be simple but I'm not having much luck so I figured I'd ask the experts.