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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query Question... 6
sqlQuery for daily plans and tasks 1
Time Zone Conversion Table 1
How To Call A SQL Stored Procedure From Access 1
Outlook crash when opening Calendar 5
Outlook 2007 crashes when saving a calendar event 10
Outlook has encountered a problem 0
Faulting application excel 1

Top