I am working in Access 2007. I have a database named Corporate that I need to update with information from Kace. I have designed a query that specifies what information that I need to update from specific tables. How can I construct an update to look at only these specific fields in these tables and then copy over the information from Kace into Corporate?
Here is my SQL pulled out of Access from the Corporate database:
SELECT OrgContact.title, Person.fname, Person.midinit, Person.lname, Person.suffix, Person.credentials, OrgContact.phone, OrgContact.fax, Org.orgname, Org.orgtypeid, Org.address1, Org.address2, Org.city, Org.state, Org.zip, Org.maddress1, Org.maddress2, Org.mcity, Org.mstate, Org.mzip, Org.phone, Org.fax
FROM (((Org INNER JOIN OrgType ON Org.orgtypeid = OrgType.orgtypeid) INNER JOIN OrgLabel ON OrgType.orgtypeid = OrgLabel.orgtypeid) INNER JOIN OrgContact ON Org.orgid = OrgContact.orgid) INNER JOIN Person ON OrgContact.personid = Person.personid
WHERE (((OrgContact.title)="Administrator" Or (OrgContact.title)="Director of Nursing" Or (OrgContact.title)="QI DIrector" Or (OrgContact.title)="QI Coordinator" Or (OrgContact.title)="QI Contact" Or (OrgContact.title)="Infection Control Contact" Or (OrgContact.title)="Hospital Reporting" Or (OrgContact.title)="HCAHPS Contact" Or (OrgContact.title)="Health Information Director" Or (OrgContact.title)="Director of Surgical Services" Or (OrgContact.title)=" CART Contact" Or (OrgContact.title)="Liason" Or (OrgContact.title)="Case Review Contact" Or (OrgContact.title)="Medicare Expedited Appeal Contact") AND ((OrgLabel.orglabelid)=18 Or (OrgLabel.orglabelid)=19));