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.