to edit data in a select query (more then 1 table referenced)

#1 (**permalink**) 28-Jul-2006, 08:11 AM

My task is simple. I have a query that refernces several tables. The result
is exactly what I need to edit. However I am unable to change any of the
table values in the query.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10242-edit-data-select-query-more-then.html

*

#2 (**permalink**) 28-Jul-2006, 08:11 AM

Generally only 1 table can be edited at a time, but you can include data
from other tables in that query. Queries must be updateable. Go into the SQL
view and try changing the select statement from:

Select ...

to:

Select Distinctrow ...
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Robert B" B@discussions.microsoft.com> wrote in message
news:49CC21E6-E251-48C5-894B-408509B959A4@microsoft.com...
> My task is simple. I have a query that refernces several tables. The
result
> is exactly what I need to edit. However I am unable to change any of the
> table values in the query.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10242
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10242