DMax

[peljo]

I want to build a delete query that deletes only the last line but only when the Yes/No field is set to True.I want to use Dmax but I make it with errors. How can I achieve this?
My simple query is like that :
SELECT baskets.basketid, baskets.England
FROM baskets
WHERE (((baskets.England)=True));

 

[lespaul]

what do you mean by "last line"? the last record that was entered in the table?

Do you have some way to determine which record that was?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi