Update Fields

[Ray67]

Hello


I have a table that has all of my patient address. This information is imported from excel. If the patient address changed i would like to change it in my table.

Example

Pt old address
350 East 179th Street AptCC508


Pt new address
350 East 179th Street AptC508


I know it can be done in query just don't recall how to do it. So i would like for query to tell me if the value has changed from any of the fields in the table.



Thank you

[ranman256]

In an update query, connect the tPatients table to the xlExcel linked file. Or if you imported the excel file tImportedXL table
If they have a common PatiendID, good.

Id have a macro run these various queries for changes:

qry: quUpdAddrs
critieria if : tPatient.Addr1 <> xlExcel.Addr1 or tPatient.Apt#<> xlExcel.Apt#

update
tPatient.Addr1 = xlExcel.Addr1
tPatient.ST = xlExcel.ST
tPatient.Apt# = xlExcel.Apt#

Id have another query for phones..quUpdPhones

critieria if : tPatient.HomePhone<> xlExcel.HomePhone or tPatient.Cell<> xlExcel.Cell

update

tPatient.HomePhone= xlExcel.HomePhone
tPatient.Cell= xlExcel.Cell

--- OR --
just have 1 QUERY that updates EVERY field , every time.

[Ray67]

Thank you for you time