Date Query

S

Steve Schanzer

I wish to have a query that gives me a range from a date to a date ie

all records between [Date] and [Todays Date]

I cannot find how to do this, help please

TIA

Steve
 
J

Jerry Whittle

Create a query for the table(s) in question.

In the criteria for the date field put in the following:

Between [Enter the Start Date] and Now()

While still in query desigm view, go up to Query on the menu and select
Parameters. Put in the following and make sure it lists Date/Time as the data
type.

[Enter the Start Date]

When you run the query it will ask you for the beginning date. The Now()
function will take care of today's date and time.

NOTE: For this to work, the date field in question must be a Date/Time data
type in the table and not just something that looks like a date in a text
field.
 
Top