Can't Delete Records Selected in MAX Query 1

[jdegeorge]

Hi

I have a query based on this SQL:

SELECT Max(tblIssues.IssueID) AS MaxOfIssueID
FROM tblIssues
ORDER BY Max(tblIssues.IssueID) DESC;

IssueID is set to AutoNum. I want to delete this record but I get an error message

[text]Could not delete from specified tables[/text]

What I'm trying to do with this query is to use it as the basis of another query to delete the last record I added.

How can I either, A) get this query to not have the record be locked, or B) figure out another way to delete the last record added.

Any help would be appreciated. Thanks!

Jim DeGeorge

 

[PHV]

A starting point:
DELETE FROM tblIssues
WHERE IssueID = (SELECT Max(IssueID) FROM tblIssues)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jdegeorge]

Nice!

Thanks, and enjoy the star!

Jim DeGeorge