Can anybody tell me the syntax in a delete query where i want to delete all records that have the date in one field older than 6 months.

Thanks a lot.

<Date()-178

Thanks,

just out of interest, what's the 178?

Number of days?

thankyou,

Neil.

yes :}

Another quick question, When the query is run, two default warning boxes come up and annoy the user. Is it possible to get rid of these?

Thanks again.

In code
DoCmd.SetWarnings = False
DoCmd.RunQuery ###
DoCmd.SetWarnings = True

Edit - typo

[This message has been edited by wh00t (edited 04-11-2002).]