Criteria for a date field to display records set for the coming 7 days

[odiejodie]

hello,
i am trying to create a query for a report to run off, which will display the up and coming dates set for the next 7 days. but i wish to be able to select the date and which person the list is valid for.

I am creating a database for a home help service and i need to be able to view what is to be done over the next seven days for the workers.

i am currently trying



DatePart("ww",[Visit Date From])=DatePart("ww",Date()) And Year([Visit Date From])=Year(Date())

although this seems to work for one date and not any other date.

Any thoughts on a solution?

Thanks.

[ConneXionLost]

Hi,

Try using this:

Between Now() And Now()+7

as criteria for the date field in your query.

Cheers,

[odiejodie]

ive just realised that..... ive used
between date() and date()+7
thank you