473,326 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Build an Update Query/Macro

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));
Jan 6 '11 #1
2 1142
Mr Key
132 100+
U just need Update Query Created from your Select Query.
Jan 11 '11 #2
Mr Key
132 100+
You may read access help for more information if you want the updating Action to be automatic and warning free
Jan 11 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: Randy Harris | last post by:
I imported records into a table, later found out that many of them had trailing spaces in one of the fields. If I'd caught it sooner, I could have trimmed the spaces before the import. This...
4
by: deko | last post by:
I'm trying to update the address record of an existing record in my mdb with values from another existing record in the same table. In pseudo code it might look like this: UPDATE tblAddress SET...
4
by: Gilberto Campos | last post by:
Hi all. I am having a strange problem. I am developping an application that acceses an Access db through Jet (.UDL files). I have writen parametric INSERT queries that work fine. I am now...
7
by: Mark Carlyle via AccessMonster.com | last post by:
I have this update query that I am trying to run. I know the syntax is messed up but do not know how to correct it. Select 'UPDATE', Transactions,'Set = where = ' From "Get Daily Balances" ...
0
by: ghadley_00 | last post by:
Run Update Query in silently in background I have a MS access 200 DB in which I have an update query which repalces all the " " with ''" in a field. I would like the update query to run in the...
4
by: Kannan s | last post by:
Dear Sir, Sub: help requred to build an Update Query using if or iif I am having two tables with the following fields I wish to create a single update query in MS Access Table1: code,...
1
by: Eric | last post by:
I create an extra field in the table, bind it to the relevant form (as in normal form design). Then to show the data. I want to run an update query on the table so that the data posted by the...
1
by: M3lancholy | last post by:
I've created a database in Microsoft Access 2003, Windows XP. It updates based on: a date range, and various other field matches. It takes this data from a form. What I'm confused about is that...
2
by: justapawn | last post by:
Can someone assist me in using the correct syntax or method of assigning a variable to the Set portion of a DoCmd.RunSQL Update Query? The help file and most sites, including ms, seem to think the...
1
by: giovannino | last post by:
Dear all, I did a query which update a sequence number (column NR_SEQUENZA) in a table using a nice code (from Trevor !). 1) Given that I'm not a programmer I can't understand why...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.