Can't edit the results of a query

[Richard Coutts]

I have a query created by the "Find Unmatched" query that lists items
in a table that were not selected by another query. The Query does
what it needs to do, but I can't edit any of the resulting fields the
way I can with other Queries. E.g., the "Descriptio n" field is a memo
field, but when I try to click on the text and edit it, I get the
fimiliar "bonk" sound, telling me I can't edit this.

Here's the SQL:

SELECT tblSpecItems.Su bsec, tblSpecItems.De scription,
tblSpecItems.In dex
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll. id
WHERE (((qryJobSpecsA ll.id) Is Null));

Thanks!
Rich

[david epsom dot com dot au]

To get an updatable query, you need to index both sides
of the join. This is done automatically if you define
a relationship between the fields, and is normally done
automatically for fields with names like 'id'.

Or perhaps it just fell over because you named a field
'index'

(david)

"Richard Coutts" <rc*****@comcas t.net> wrote in message
news:70******** *************** ***@posting.goo gle.com...

I have a query created by the "Find Unmatched" query that lists items
in a table that were not selected by another query. The Query does
what it needs to do, but I can't edit any of the resulting fields the
way I can with other Queries. E.g., the "Descriptio n" field is a memo
field, but when I try to click on the text and edit it, I get the
fimiliar "bonk" sound, telling me I can't edit this.

Here's the SQL:

SELECT tblSpecItems.Su bsec, tblSpecItems.De scription,
tblSpecItems.In dex
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll. id
WHERE (((qryJobSpecsA ll.id) Is Null));

Thanks!
Rich

[Richard Coutts]

> To get an updatable query, you need to index both sides

of the join. This is done automatically if you define
a relationship between the fields, and is normally done
automatically for fields with names like 'id'.

Or perhaps it just fell over because you named a field
'index'

I'm a newbee (a wizard wrote my SQL) and not sure what you mean by
indexing both sides of the join -- can you elaborate?

I simplified the query to get limit the number of fields and hopefully
any conflicts with the 'index' field, but I still can't edit the
results. The simpler query looks like this:

SELECT tblSpecItems.id , tblSpecItems.De scription
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll. id
WHERE (((qryJobSpecsA ll.id) Is Null));

Rich

[david epsom dot com dot au]

Open qryJobSpecsALL, and see if you can edit there.

If you can't edit in qryJobSpecsAll, you won't be able
to edit in any derived query. Post the SQL for
qryJobSpecsAll if that is the problem.

(david)
"Richard Coutts" <rc*****@comcas t.net> wrote in message
news:70******** *************** ***@posting.goo gle.com...

To get an updatable query, you need to index both sides
of the join. This is done automatically if you define
a relationship between the fields, and is normally done
automatically for fields with names like 'id'.

Or perhaps it just fell over because you named a field
'index'

I'm a newbee (a wizard wrote my SQL) and not sure what you mean by
indexing both sides of the join -- can you elaborate?

I simplified the query to get limit the number of fields and hopefully
any conflicts with the 'index' field, but I still can't edit the
results. The simpler query looks like this:

SELECT tblSpecItems.id , tblSpecItems.De scription
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll. id
WHERE (((qryJobSpecsA ll.id) Is Null));

Rich