next 7 days (1 Viewer)

[w0od0o]

Hi,

i have a query to find all jobs with a completion date within the next 7 days with the following criteria under "completion date" but it doesnt seem to filter correctly, i thought it worked correctly on a test database but when added to the final database it seems to produce all records.

<DateAdd("d",7,Date()) Or Is Null

all help welcome

thanks

w0od0o

 

[vbaInet]

Use between today's date and Date() + 7, followed by your Is Null.

 

[w0od0o]

thank you

 

[vbaInet]

You're welcome