Search results

thanks Minty, I'm not sure what your saying, I could generate a table of all UK 4 byte postcodes (up to the break) and then format the file I need to flag to allow matching but the problem I have is people who would need to run this in my absence aren't access savvy at all so just want them to...

HI, I want to automate to below script which i normally manually run to check any file imported into a access database, it just needs to check the postcode and update a new column with a flag to show it matches. UPDATE [UK A19EDA] SET [UK A19EDA].[UK Postcode] = "Y" WHERE ((([UK...

hi, I need to update some columns called "ask1", "ask2","ask3" they need to be updated but a column called "ask Calc" and in ask1 need to be 1.25 x ask Calc value, ask2 needs to be 1.50 x calc value and ask3 2 x cal value how do I do this? thanks

Hi, I need to run a dedupe macro based on the following, Files supplied fields: Title, Forename, surname, address line 1 & postcode I want to run a dedupe and flag where the files match on the following Criteria, address line 1 & postcode and create an additional field which states the...

Thanks Ranman, I managed to sort out what I was doing wrong the code works a treat, your help is much apricated, have many more questions regarding macros for dedupe queries etc. will get these typed up tomorrow and hopefully you can assist again! :-)

Hi Sorry, thanks for this but as I said before I'm a total newbie when I paste your query I get path not found, now I know its something really silly. the folder my files are located in is called "originals" on my C:\ and it contains 5 .csv file called 1, 2, 3, 4 , 5 the error message I get is...

HI, I'm very new to this so please explain in simple terms! I have found the code below to import multiple .csv files into one table but I now need to append the file name to each file once its been imported so I can keep a track, if this is possible and as I'm very new to all this could you...