I have a database that contains all of my company's sales information for the last two years. I am making a form that will be used by managers to filter the information and produce a corresponding report. The managers will filter the information by choosing criteria in combo boxes. The form is linked to a query that combines the tables containing the sales information. I need the managers to also be able to specify which beginning and ending dates for sales in the filter criteria. For example, one may want all sales by a certain person from May of 1999 to August of 1999. I would like them to type this date criteria into a box. I have tried to accomplish this by making unbound text boxes on the form and writing an SQL statement for the Sales Date field of the query, but this does not work as the query is run when the form is opened, resulting in a blank form due to the date boxes on the form having no entries. Does anyone have any ideas? Thanks!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.