Delete Query Help

[Sam]

Can someone tell me how to delete all records in a table and keep only the
last one using a query?

thanks.

sam.

 

[Lynn Trapp]

Sam,
How do you define "the last one"?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Sam]

the last record keyed in, so having the last id (autonumber).

 

[Gary Walter]

PMFBI

(replace yurtable w/ name of your table)

DELETE * FROM yurtable
WHERE [id] < DMax("id", "yurtable")

 

[Sam]

thanks Gary,

It works exactly as i wanted.

cheers.

PMFBI

(replace yurtable w/ name of your table)

DELETE * FROM yurtable
WHERE [id] < DMax("id", "yurtable")

the last record keyed in, so having the last id (autonumber).