If possible edit the data from query ?

[tran1728]

Dear all,

I use Access 2003, i join 2 tables and impossible to change the data from
the table query.

Please It is possible Edit the data from the table query ?
Thanks so much for your reply.

Tran1728

 

[Duane Hookom]

It is possible to edit records in a query consisting of one or more tables.
The tables should be joined on the primary and foreign key fields. The query
can't be a Totals or Crosstab query.

If you have a query that you can't edit records, consider providing the SQL
as well as the table relationships and key fields.

Duane Hookom
MS Access MVP

 

[tran1728]

Thank you so much for your help, but i am not a specialist.
pls can you send me an example to (e-mail address removed) ?

Thanks again
tran1728

 

[Duane Hookom]

Consider answering my request if you want some assistance.

 

[tran1728]

Hi, Duane Hookom,
Yes, I need some assistance.

Thanks.
Tran1728

 

[John Spencer]

If you want an answer you must provide the information requested.
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

Also, it would be a big help if you told us about the tables involved. At the
very minimum, you should answer the following.
Do they have a primary key? If so, what are the field names?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County