I would like to design a query in Access that would filter my data by week. Access offers ready-made querys for day, month, quarter, and year but not week.
I already have an Excel file that does this with array formulas, but they are extremely slow on older machines and I think Access might have the spunk I need for this. I would like my results to look like this on the query:
Week Range
Begin End Quantity
5-1-02 5-7-02 55
5-8-02 5-14-02 450
... ... ...
I have played with the criteria in the query pages, but I always end up with error messages. Any ideas on how I could configure the criteria field in my query or any other way of doing this would be great!!!
Thanks, Waymond
It's amazing how much can be done when no one cares who gets the credit!
I already have an Excel file that does this with array formulas, but they are extremely slow on older machines and I think Access might have the spunk I need for this. I would like my results to look like this on the query:
Week Range
Begin End Quantity
5-1-02 5-7-02 55
5-8-02 5-14-02 450
... ... ...
I have played with the criteria in the query pages, but I always end up with error messages. Any ideas on how I could configure the criteria field in my query or any other way of doing this would be great!!!
Thanks, Waymond
It's amazing how much can be done when no one cares who gets the credit!