Recent content by Navyguy

@Pat Hartman That is correct. There was an imported table (new_info) with information from another sources. Once the info was appended to the Tbl_People and then updated in the Tbl_Contact_Info , the table (new_info) was deleted. Thanks again for the assistance. Cheers John

@rnelgp Thanks for this. I think you have led me to the issue I did not realize was present in the actual database. In the table new_info some of the records do not have a matching record in the [Tbl_Contact_Info].[Contract_Number] so they are not updating. I just realized this when I looked...

Thanks for your answers... still not working. I am going to try updating one field at a time and see what that brings... it is not making sense. I have double checked the field properties and all are the same in both tables. I have tried various joins with no positive results. I have other...

Good Day All I have what seems to be a simple update query that I cannot get to work. Not sure if it is the newer version of Access or I am just doing something wrong (which is more likely the case LOL). An imported table (new_info) contains random information that needs put into the matching...

Hi MarkK Thanks again. Tbl_Contact.Contact_Number would be the actual relay terminal number (1-10) that the wire is landed on. What does not exist is the Tbl_Relay.Relay_Number so not 100% sure what I would do there. Perhaps like I thought maybe a yes/no, but I am not really a fan of yes /...

Hi MarkK Thanks for the quick reply... so to plot this out I would have: Tbl_Relay Relay_ID – PK – Autonumber Equipment_ID - FK Relay_Number (I am not sure what I would call it; maybe just a yes / no?) Tbl_Contact Contact_ID – PK – Autonumber Relay_ID – FK Contact_Number (select from 1 to 10...

Empty Columns / Fields – Normalization Looking for some advice here; I have several tables that have a similar issue that I am not sure really is an issue. I just might be trying to over complicate it. Each table has a primary key and then several “place holders” that may be used. The...

Hello All Just an update, I decided to scrap the whole thing and start fresh... It is now working. I am not sure what the issue is / was but it is not sorted out, but I went back to the basics, I I must have had some setting or code somewhere that was conflicting... don't know. Thanks...

Hi arnelgp I actually took the comma away previously knowing that I cannot have two criteria on a SELECT DISTINCT; however I did try your suggestion again and continue to get a syntax error on the WHERE portion of the clause. I have to admit, I am not convinced that it is the query that is the...

Hi spikepl, I have no idea what you are talking about, but thanks for the suggestion. Cheers

I just watched the videos from another machine... good videos and I think I am on track with the combos. Cheers

Hi jdraw For some reason they don't work here... I have a pretty good connection and machine... maybe I will try a different browser... Here is a pic of the relationship window for your comments. Generally the Equipment_ID_Number is the main thing connect to all things - think of it like a...

Hi jdraw I have to admit, I did not consider zipping up such a small file... I note that the zip attachment limits are larger and will endeavour to do that next go around. Feel free to edit my previous posts so that can be done for the benefit of the group. Edit - I just realized I could...

Hi arnelgp I tried the above and kept getting a syntax error on the WHERE Clause. I played around with it a bit adding and removing brackets, adding and removing spaces and added the semi colon. Could not seem to get the error to go away. I took your idea and created a duplicate query and...

Hi spikepl I tried to that originally, however the file size was too large to allow attachment, thus used my personal FTP site. File size is limited to 100 KB and these were slightly over that amount. Edit - I used the suggestion from jdraw and was able to add the file to both posts as per...