Criteria for range of date

[jer]

Some help please. I am trying to query a range of dates, but because the
date is formatted date time I am using datevalue to query the date part. How
do I structure the criteria to allow the user to input a range of date. I
have attempted the following, but this does not work. Any help / suggestions
would be greatly appreciated

SELECT [Confirmations].Subject, [Confirmations].From,
[Confirmations].Received, DateValue([Received]) AS [Date]
FROM [Confirmations]
WHERE (((DateValue([Received])) Between DateValue([received])=[enter date]
And DateValue([received])=[enter date]));

 

[Joshua A. Booker]

Jer,

If the feild received is in an access table of the type Date/Time, you can
forget about the formatting.

WHERE [Received] Between [Enter Start Date] And [Enter End Date]


HTH,
Josh

 

[Tom Ellison]

Dear Jer:

ALMOST!!!!

How about:

SELECT Subject, From, Received, DateValue([Received]) AS [Date]
FROM [Confirmations]
WHERE DateValue([Received]) Between DateValue([enter beginning date])
AND DateValue([enter ending date])

Does this help?

Tom Ellison

 

[jer]

Dear Tom
Works just fine
thanks a lot
--
thanks as always for the help
jer

Dear Jer:

ALMOST!!!!

How about:

SELECT Subject, From, Received, DateValue([Received]) AS [Date]
FROM [Confirmations]
WHERE DateValue([Received]) Between DateValue([enter beginning date])
AND DateValue([enter ending date])

Does this help?

Tom Ellison

Some help please. I am trying to query a range of dates, but because the
date is formatted date time I am using datevalue to query the date part.
How
do I structure the criteria to allow the user to input a range of date. I
have attempted the following, but this does not work. Any help /
suggestions
would be greatly appreciated

SELECT [Confirmations].Subject, [Confirmations].From,
[Confirmations].Received, DateValue([Received]) AS [Date]
FROM [Confirmations]
WHERE (((DateValue([Received])) Between DateValue([received])=[enter date]
And DateValue([received])=[enter date]));