Can't delete records in a query

[melaniews]

I often run a query and then delete the records that show up. I've got two tables. There is only one field in each table. I put both tables there, join on the field. Put the field in the grid that I want to see. Run the query. It gives me all records that are equal. At this point usually I just delete these records that I have found. But it is not working on my current project. any help here would be appreciated. I'm baffled as to why it has always worked fine in the past and now doesn't work. I tried using a delete query and it tells me that it can't delete from the table. ??????

TIA
Melanie

 

[dumdum]

Can you explain a little more? I'm sorry but what you're doing doesn't make sense. Why do you have a table with only 1 field? We are always looking for new members at our computer forums:

http://forums.jlrforum.net