Selection of date range

[Anthony Lisanti]

I have a small table that covers an entire year of sales

I need to make a way to select he date range, and sales Agent type and
display the pounds purchased for that week.


So I'd like a selection box "enter Date range" (weekly) & type of
Customer Affiliate Domestic, Affiliate international, Domestic
Customers, International Customers.


Should be simple, eh?

Any advice?

 

[Arvin Meyer [MVP]]

Just add a little form with 2 textboxes: txtStart and txtEnd

Then use the following query criteria:

For the dates:

Between Forms!FormName!txtStart And Forms!FormName!txtEnd

For the CustomerType, use a combo box on the form and the following criteria
in the query:

Like Forms!FormName!cboCustomerType & "*"

Which will allow the user to choose a customer, or leave it blank for all
customers. If you want a calendar to pick your dates try the one at:

http://www.datastrat.com/Download/Calendar2K.zip

 

[Tom Wickerath]

Anthoney,

Here is a zipped sample database, with a "how-to" Word document that
explains the technique Arvin just outlined:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________