Dates in a query - Help!

[redz]

Hi

I am far from an expert using Access and am having trouble working out criteria for a query - I am sure it is very simple really.

The query is to work out a date when a letter has to be sent out to someone.

I would have 'today's date' + 28 days = 'new date' and display the data for records where the 'new date' is less than 14 days away.

Does that make sense.

I hope someone can help me with this!!

Redz

 

[antomack]

Assuming the 'New Date' is in the table you are querying and has been set to the required date then just use the following as the criteria under the 'New Date' field.

Between Date() and Date() + 14