Using Dates in a query

[DasT]

I've never used queries before so forgive me if this sound confusing

I have a table set up with several differn entries (too many to list) one of which is an 'action due by date' and another is 'Primary Contact' I need a query set up to check first the contact and then if the date is both between the dates of the following week (the reports will be pulled off on a friday) or anything less than this i.e. the due by date is anything earlier than the Friday of next week (something like < today + 7)

Then once its found all of these it needs to show all the different entries that correspond so these reports can be printed.

Hope thats been explained well enough, if it not let me know

thanks for your help

 

[Norie]

Actually I didn't but I forgot that the mathematical symbol for less than is also a code tag.

What it should be is

"<" DateAdd("ww",1,Date())

Remove the quotes when you use it.

 

[DasT]

I think i may have found a working formula i've used

<=DateAdd("d",7,Date())

which seems to work, if this looks wrong please let me know

thanks for all your help

 

[Norie]

It looks fine.

How did you post the less than sign?

 

[jsi]

Sorry, I mis read your post, Glad you got it working. Thanks for jumping in Norrie (I went home early yesterday)
Jim