troubleshooting Question

APPEND QUEREY ADD TEXT TO WRONG RECORD

Avatar of Divinedar0923
Divinedar0923 asked on
Microsoft Access
69 Comments1 Solution325 ViewsLast Modified:
I have the following:

INSERT INTO tblTestName ( Site_Designator )
SELECT tblShelterNames.Site_Designator
FROM tblShelterNames LEFT JOIN tblTestName ON tblShelterNames.Site_Designator = tblTestName.Site_Designator
WHERE ((([tblShelterNames]![Select_Site])=-1));

It inserts what I want it to insert but it adds a new record with the data that it inserts.  It does not insert the data on the row.

I tell you this:  both tables have checkboxes.  If tblShelterNames (Main Table) is checked, it should add the site_designator to all the records checked in tblTestName.  This is a Many (tblTestName) to One (tblShelterNames) relationship.

How do I get the data tblShelterNames (one field with data) on the rows that are checked in the tblTestName table (many fields with data)?

All my questions is very urgent as I'm trying to meet a deadline.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 69 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 69 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros