Selection of date range

  • Thread starter Thread starter Anthony Lisanti
  • Start date Start date
A

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?
 
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
 
Back
Top