Finding record between two Dates Queries

[ashhush]

I have table named challenge and it has many fields such that ID, First Name,
Last Name etc I want to find out the total number of challenge records that
are available between two dates (The dates will be entered by us through
command prompt).
Please do let me know if you need further information.

 

[Jeff Boyce]

Does that table have one date field or more? Which date field(s) do you
want the query to be comparing to?

Check Access HELP for "parameter query".

Regards

Jeff Boyce
Microsoft Access MVP

 

[Guitarzann]

First, create two control boxes on your input form. You can label them,
"from" and the other, "to."
Next, create a query that pulls the dates from the "challenge" table. Inside
the criteria of the date field, type: "Between [forms]![yourformname]![from]
and [forms]![yourformname]![to]."

This will return all records within the date range the end user has selected
in the form.