|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 13th, 2010, 06:14 AM
posted to microsoft.public.access.queries
|
|||
|
|||
If possible edit the data from query ?
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 
|
|
#2
February 13th, 2010, 07:48 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
If possible edit the data from query ?
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" wrote in message ... 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
|
|
#3
February 23rd, 2010, 01:24 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
If possible edit the data from query ?
Thank you so much for your help, but i am not a specialist.
pls can you send me an example to ? Thanks again tran1728 "Duane Hookom" wrote: 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" wrote in message ... 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
|
|
#4
February 23rd, 2010, 01:30 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
If possible edit the data from query ?
Consider answering my request if you want some assistance.
-- Duane Hookom MS Access MVP "tran1728" wrote in message ... Thank you so much for your help, but i am not a specialist. pls can you send me an example to ? Thanks again tran1728 "Duane Hookom" wrote: 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" wrote in message ... 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
|
|
#6
February 23rd, 2010, 01:10 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
If possible edit the data from query ?
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 tran1728 wrote: Hi, Duane Hookom, Yes, I need some assistance. Thanks. Tran1728 "Duane Hookom" wrote: Consider answering my request if you want some assistance. -- Duane Hookom MS Access MVP "tran1728" wrote in message ... Thank you so much for your help, but i am not a specialist. pls can you send me an example to ? Thanks again tran1728 "Duane Hookom" wrote: 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" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
