MS Access 2002

[Larry Rutter]

I have a simple question - How does one delete a record
from a query that is linked to two tables. My query is
used to select a time frame in which data was pulled from
my website. Some customers do duplicate searches and I
manually edit their searches to eliminate duplicates. If
I can't manually delete duplicate records from the query
then I have to open the table and sort out the data by
customer and time frame to delete the duplicate record
(s). To be able to delete records from the query would be
a big help. I have tried to reset permissions but nothing
I do helps. When I try to delete a record in the query
all I get is a bell sound.

 

[John Viescas]

Access must think that your query is not updatable. Please post the SQL
from your query and the relevant info about the tables involved - Primary
and Foreign Keys.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)