Query Syntax (1 Viewer)

[Neilw]

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.

 

[wh00t]

<Date()-178

 

[Neilw]

Thanks,

just out of interest, what's the 178?

Number of days?

thankyou,

Neil.

 

[wh00t]

yes :}

 

[Neilw]

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.

 

[wh00t]

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

Edit - typo

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