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!