Query involving a date calculation

[bronzyroo]

Hi All,

I currently have a database which includes a date field (InitialDate).

Basically, I need to design a query that will prompt me to take action on any record for which the date under InitialDate is > or = 6 months ago. Alternatively this couuld be coded as InitialDate + 6 months > or = today's date. I also want to add an additional condition stipulating that the query is not to include any records that have anything entered in a seperate field (ActionTaken).



As I know very little about access/ programming I have no idea where to start. Can someone help me out?

[June7]

Have a query with criteria under the InitialDate field to retrieve records where the InitialDate is before 6 months ago.

Current date is 2/14/2012

<= DateAdd ("m",-6,Date())

will return records with InitialDate earlier than or equal to 8/14/2011.

Criteria under ActionTaken could be (to handle possibility of null or empty string - I don't allow empty strings in tables):
Is Null Or <> ""

Is that what you want?

[bronzyroo]

That is exactly what I needed. Thank you so much