Criteria

[Vinnie via AccessMonster.com]

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,

 

[pietlinden]

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:]));

 

[Vinnie via AccessMonster.com]

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...)

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