Hello,
I am attempting to create labels from my database. The labels come from a report that I automatically fill from a table. The issue I am having is with updating my table.
I have two tables one is called Components and the other is Blue Tag Log. The Components table gets it's information from tables (filled through user interface forms within the the database) that I extract the required data from using queries. I want to be able to check the Components table and only pull data where the STP (short for system turnover package) field is filled. I then want to take these entries with STP filled, compare the tag field of the Components table to the tag field of existing entries in the Blue Tag Log, and only add the instances that do not already exist in the Blue Tag Log table. Is there an easy way to do this? I was attempting to do so with an Update query where the tag fields were joined between the two tables but it doesn't seem to do anything. (See SQL code below)
Code:UPDATE [Blue Tag Log Test] RIGHT JOIN BlueTagComponent ON [Blue Tag Log Test].DEVICE = BlueTagComponent.CompTag SET [Blue Tag Log Test].DEVICE = [BlueTagComponent].[CompTag], [Blue Tag Log Test].[STP NO] = [BlueTagComponent].[STPNo], [Blue Tag Log Test].[STP NAME] = [BlueTagComponent].[STPDesc], [Blue Tag Log Test].[EID NO] = [BlueTagComponent].[DrawingNo], [Blue Tag Log Test].[LINE 1] = [BlueTagComponent].[Line1], [Blue Tag Log Test].[LINE 2] = [BlueTagComponent].[Line2], [Blue Tag Log Test].[LINE 3] = [BlueTagComponent].[Line3] WHERE ((([Blue Tag Log Test].[STP NO])<>"" Or ([Blue Tag Log Test].[STP NO]) Is Not Null));
Additionally, I want to add a feature where the existing data within the Blue Tag Log could be refreshed when new information was added to the database.
Any help would be appreciated. I have experience with Access but I can't seem to wrap my head around this one.