Date Query

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I would like to create a query that asks for a date range.

I would like to know the first name, last name and DOD (all field names)
based upon a users entry of a date range.

Thank you
 
I would like to create a query that asks for a date range.

I would like to know the first name, last name and DOD (all field names)
based upon a users entry of a date range.

Thank you
Click to expand...

As criteria for the Date field, write:
Between [Enter start date] and [Enter end date]

When you run the query you will be prompted to enter the dates.
 
I would like to create a query that asks for a date range.

I would like to know the first name, last name and DOD (all field names)
based upon a users entry of a date range.

Thank you
Click to expand...

Create a Query based on your table. Select the three fields; under the
date field on the Criteria line put
= CDate([Enter start date:]) AND <= CDate([Enter end date:])
Click to expand...

using whatever prompts you prefer in the square brackets.
 
Thank you!

John Vinson said:
I would like to create a query that asks for a date range.

I would like to know the first name, last name and DOD (all field names)
based upon a users entry of a date range.

Thank you
Click to expand...

Create a Query based on your table. Select the three fields; under the
date field on the Criteria line put
= CDate([Enter start date:]) AND <= CDate([Enter end date:])
Click to expand...

using whatever prompts you prefer in the square brackets.
Click to expand...
 
Back
Top