Criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vinnie - 11 Aug 2006 09:54 GMT

Hi,

I've got a query that asks you for a specific date and returns details on
that date: [What Date?] in the 'Criteria' field

What I'd like to do is return details between two certain dates. In other
words, in the 'Criteria' field return between [Start Date?] and [End Date?],
but I don't know the syntax, or even if its the right way to go about this.

Any help much appreciated!

Thanks,

Reply to this Message

pietlinden@hotmail.com - 11 Aug 2006 10:44 GMT

Wow. If you think for just another second, you'll have the answer.
(waiting...)

SELECT Orders.OrderID, Orders.OrderDate
FROM Orders
WHERE (((Orders.OrderDate) Between [Enter start date:] And [enter and
end date:]));

Reply to this Message

Vinnie - 11 Aug 2006 11:57 GMT

Nice one!

I see I was close, yet very far way!

Thanks again...

>Wow. If you think for just another second, you'll have the answer.
>(waiting...)
[quoted text clipped - 3 lines]
>WHERE (((Orders.OrderDate) Between [Enter start date:] And [enter and
>end date:]));

Reply to this Message