Forms and Queries and Reports

M

Marc

I want to have a form with the fields "start date" and "end date" and I would
like to be able to enter the dates and hit a button on the form to bring up a
report using the dates I entered. I know how to write the query and I know
that I can have pop up boxes to enter the dates but would rather have a form.
Any ideas?
 
J

Jeff L

I am assuming you are wanting to put in a date range. To do that, in
the criteria of your query for your report put
Between Forms!YourFormName!StartDate And Forms!YourFormName!EndDate
 
M

Marc

So the "start date" and " End date" fields on the form...I don't want the
dates to be tracked just want a search the range of dates. Do I need to do
anything special to the fields?
 
J

Jeff L

Nope. You can set the format if you want in the properties, but there
isn't anything that you have to do to the fields.
 
Top