query help

[gbanks]

Does someone know how I can show in a query all records older than 2 weeks but not greater than today's date? I have a table that has all the data with a date field. I want to show records that are older than 2 weeks but not greater than todays date. This is used for appointments. Thanks

 

[SteveA]

I'm not sure what you mean by older than two weeks and not greater than today. If you mean an appointment that was dated in the last two weeks ie between 31st Dec 2001 and 11 Jan 2002 then place the following below the date field in your query:

>=DateAdd("d",-14,Date()) and <=Date()

If this isn't what you're after please let me know.

Cheers,
SteveA

 

[gbanks]

That's it Steve. Thanks..