Some questions about the date range

[Nathan Plemons]

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.

[pbaldy]

In design view, change "Group By" to "Where".

[Nathan Plemons]

Well I would have swore I tried that a hundred times and it didn't work, but it works now. Thanks!

[pbaldy]

I pushed the magic button that makes it work for you.

Happy to help.

[Nathan Plemons]

Based on my previous experiences with some MS products, I wouldn't doubt that a bit.