Access 2000 - reporting/query within specified dates??

[Nick]

Excuse my ignorance because I am an absolute newbie to Access and this is my
first attempt at a database. I'm creating a database to record volunteers
names, start date, end date and that's it. I would like to be able to create
a report on which volunteers were working between specified dates.

So far, which isn't that far to be fair, I've created a simple table with
the fields VolunteerID (Autonumber), FirstName (Text), LastName (Text),
StartDate (Date), EndDate (Date). I've also put some data in the fields to
play around with. I've created a report that details all of the entries and
looks fine(A report with Start Date, End Date, FirstName, LastName. I haven't
created any forms or anything yet.

So, my question is - what is the best method of creating a report from
specifying/inputting a start date and an end date and producing the results
within these dates in the kind of report I have already created? Please help
- I'm absolutely lost.........

 

[Beetle]

Create a query that includes all the fields from your table. In the
criteria row for the StartDate field put;

=[Enter a Starting Date]

in the criteria row for the EndDate field put;

<=[Enter an Ending Date]

Now use the query as the record source of your report. When the report
is run you will be prompted to enter the dates.

You could also create a form where the users would enter the dates, and
use the contol values on the form as criteria in the query.

 

[Arvin Meyer MVP]

Use a query as the recordsource of the report and use a form to supply the
start and end dates that you want to see. In the query criteria add:

=[Forms]![YourForm]![StartDate]

<=[Forms]![YourForm]![EndDate]

in the appropriate fields.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Isaura was here]

hay wuz up name is girft ya now it is werdi