Criteria

[Loi]

Hi,

In criteria at design view of query, I type in [Type in
the date]and I run query. By typing in any date in
parameter box, it will pull out a list of that date
information.

Ex: if i type in, 8/20/04, I can have a list of 8/20/04.
It is good.
------------
I would like to know a criteria which will show all
information of the date 8/20/04 + two dates after 8/20/04

Please show me a criteria which will show anydate+two
dates after that date.

Ex:when I type 8/20/04 in parameter box , it will show
3days in row like 8/20/04, 8/21/04/8/22/04.
Thank you
loi

 

[Van T. Dinh]

Provided that your Date Field only store date value (and not the time
component), you can use:

BETWEEN [Type in the date]
AND DateAdd("d", 2, [Type in the date])

type as ONE line in the criteria row.