-
update query
I am using Access 2000. I am having problem with my update query based on
2 tables. There is a Main table & then there is a table
called Update, that are joined by promary key PID. The
Update table has the values only in some cells of each
record that i want to put in Main table. I do not want to
copy the whole row from Update table to Main table. I
tried specifying creteria as:
[Update]![Cell_name] is Not Null
But this doesn't work as probably you can only specify
criteria for the cells to be updated TO. I don't know if
there is any way to specify criteria for the cells to be
updated FROM.
Any help on this will be very much appreciated.
Thanks! Hi everybody,
I am having problem with my update query based on 2
tables. There is a Main table & then there is a table
called Update, that are joined by promary key PID. The
Update table has the values only in some cells of each
record that i want to put in Main table. I do not want to
copy the whole row from Update table to Main table. I
tried specifying creteria as:
[Update]![Cell_name] is Not Null
But this doesn't work as probably you can only specify
criteria for the cells to be updated TO. I don't know if
there is any way to specify criteria for the cells to be
updated FROM.
Any help on this will be very much appreciated.
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|