By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,714 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,714 IT Pros & Developers. It's quick & easy.

Can't edit the results of a query

P: n/a
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 "Description" 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.Subsec, tblSpecItems.Description,
tblSpecItems.Index
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll.id
WHERE (((qryJobSpecsAll.id) Is Null));

Thanks!
Rich
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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*****@comcast.net> wrote in message
news:70**************************@posting.google.c om...
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 "Description" 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.Subsec, tblSpecItems.Description,
tblSpecItems.Index
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll.id
WHERE (((qryJobSpecsAll.id) Is Null));

Thanks!
Rich

Nov 13 '05 #2

P: n/a
> 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.Description
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll.id
WHERE (((qryJobSpecsAll.id) Is Null));

Rich
Nov 13 '05 #3

P: n/a
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*****@comcast.net> wrote in message
news:70**************************@posting.google.c om...
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.Description
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll.id
WHERE (((qryJobSpecsAll.id) Is Null));

Rich

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.