Delete Query (Acc2000)

Topic

New Reply

I have to delete all records in a main table that have a maximum date in a many table.
Ex., For each member that has not ordered anything since 01/01/99, delete this member.

I’m stumped….

Thanks for any help as to how to accomplish this. A delete query does not allow a Max function, or I’m not doing something correctly.

Reply | Quote

Replies

Have you tried use DMax in your WHERE clause? Something like:

WHERE DMAX("OrderDate","Orders","CustomerID=" & CustomerID)<#1/1/99#

Reply | Quote