If possible edit the data from query ?

  • Thread starter Thread starter tran1728
  • Start date Start date
T

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
 
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
 
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
 
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
 
Back
Top