Search results

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...

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...