Forms and Queries and Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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