Update Question

M

Michelle

I have a form that keeps track of updates made to another table. However
what I would like is to update the other table with the changes.
Example
I have 1 table called IP Data and 1 called IPCData
I have 10 fields in each table and sometimes only one of the 10 fields gets
updated how whould I be able to tell the query to only update that data in
IPData if there is data in IPCData.
IPData
IP MAC User Internet
SWPrt
1.1.1.1 00-00-00-00-00 jsmith no 5-2
1.1.1.2 00-00-00-00-01 bsmith yes 1-20


IPCData

IP MAC User Internet
SWPrt
1.1.1.1 dsmith yes
1.1.1.2 00-00-00-00-07
1-7

after I run the updat the IPDat should look like this....


IP MAC User Internet
SWPrt
1.1.1.1 00-00-00-00-00 dsmith yes 5-2
1.1.1.2 00-00-00-00-07 bsmith yes 1-7

right now I am getting this as results

IP MAC User Internet
SWPrt
1.1.1.1 dsmith yes
1.1.1.2 00-00-00-00-07
1-7
 
Top