N Neilw Registered User. Local time Today, 19:41 Joined Mar 13, 2002 Messages 36 Apr 11, 2002 #1 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.
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 Registered User. Local time Today, 19:41 Joined May 18, 2001 Messages 264 Apr 11, 2002 #2 <Date()-178
N Neilw Registered User. Local time Today, 19:41 Joined Mar 13, 2002 Messages 36 Apr 11, 2002 #3 Thanks, just out of interest, what's the 178? Number of days? thankyou, Neil.
wh00t Registered User. Local time Today, 19:41 Joined May 18, 2001 Messages 264 Apr 11, 2002 #4 yes :}
N Neilw Registered User. Local time Today, 19:41 Joined Mar 13, 2002 Messages 36 Apr 11, 2002 #5 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.
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 Registered User. Local time Today, 19:41 Joined May 18, 2001 Messages 264 Apr 11, 2002 #6 In code DoCmd.SetWarnings = False DoCmd.RunQuery ### DoCmd.SetWarnings = True Edit - typo [This message has been edited by wh00t (edited 04-11-2002).]
In code DoCmd.SetWarnings = False DoCmd.RunQuery ### DoCmd.SetWarnings = True Edit - typo [This message has been edited by wh00t (edited 04-11-2002).]
