Recent content by GideonR

OK Thanks isladogs, I will post something a bit later when I put it together. How do I post a zip file? GideonR

isladogs, I do understand the requirement for matched data, but if I have a table with a look up field but want to populate the data from a third table's data which doesn't match but provides the result I need then how is that done? Example: tblThings has 2 fields ID (number) and Things...

Thanks for the welcome everyone. GideonR

Hi Isladogs, OK thanks for the thoughts on syntax, as I said in my intro I am very rusty. the "/" was legacy from the import as were the spaces (excel) The AddNo at the beginning is to try and get some understanding and order into data that is confused when I get it. I only want to use the...

Thanks for coming back June7 I'll clarify Original table is from Excel and has fields such as Town, Street, Close, building name, etc. to build up a comprehensive address, along with other private data NDATA (Table derived from the original data) BuildingName (text string) Town (text...

Thanks I am extremely rusty. I have posted in Query if you get a chance to have a look, I would much appreciate it. I can see there are a lot of really experienced folk on here. I don't want to take the michael learning off you folks but there is only so long I can bang my head. GideonR

Hi There, I am trying to append address data from a table which I imported from excel and have created a number of lookup tables from (e.g. Town, StreetName, etc.) and want to append the original data into a new table linking to the lookup tables. I know that the ID field on the new tables...

Hi, Based in the UK and work in the Renewable Energy and Sustainability industries among other things. I am getting back into access after about 20yrs. Still have the access '97 and sql books but am so so rusty. Looking forward to hopefully not asking to many stupid questions of you helpful...