New_to_this
New member
- Local time
- Today, 16:37
- Joined
- Nov 20, 2018
- Messages
- 7
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 A19EDA].Postcode) Like Like "AL*" Or Like "BN*" Or Like "CM*" Or Like "CT*" Or Like "GU*" Or Like "HP*" Or Like "LU*" Or Like "ME*" Or Like "MK*" Or Like "OX*" Or Like "PO*" Or Like "RG*" Or Like "RH*" Or Like "SG*" Or Like "SL*" Or Like "SO*" Or Like "SS*" Or Like "TN*" or br* or cr* or da* or e#* or ec* or en* or en* or ha* or ig* or kt* or n#* or nw* or rm* or se* or sm* or sw* or tw* or ub* or w#* or wc* or wd* or Like "DH*" Or Like "DL*" Or Like "HG*" Or Like "HU*" Or Like "LS*" Or Like "NE*" Or Like "SR*" Or Like "TS*" Or Like "WF*" Or Like "YO*" or Like "BB*" Or Like "BD*" Or Like "BL*" Or Like "CA*" Or Like "CH*" Or Like "CW*" Or Like "FY*" Or Like "HD*" Or Like "HX*" Or Like "L#*" Or Like "LA*" Or Like "M#*" Or Like "OL*" Or Like "PR*" Or Like "SK*" Or Like "WA*" Or Like "WN*" or Cb* or co* or de* or dn* or ip* or le* or ln* or ng* or nr* or pe* or s#* or B#* or cv* or dy* or hr* or nn* or st* or tf* or wr* or ws* or wv* or Like "BA*" Or Like "BH*" Or Like "BS*" Or Like "DT*" Or Like "EX*" Or Like "GL*" Or Like "PL*" Or Like "SN*" Or Like "SP*" Or Like "TA*" Or Like "TQ*" Or Like "TR*" or like bt* or Ab* or dd* or dg* or eh* or fk* or g#* or hs* or iv* or ka* or kw* or ky* or ml* or pa* or ph* or td* or ze* or Like "CF*" Or Like "LD*" Or Like "LL*" Or Like "NP*" Or Like "SA*" Or Like "SY*" or like “JE*” or like “GY*” or like “IM*” ));
would be most grateful for any assistance, im quite new to automatic procedures so please explain in simple terms!!
thanks
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 A19EDA].Postcode) Like Like "AL*" Or Like "BN*" Or Like "CM*" Or Like "CT*" Or Like "GU*" Or Like "HP*" Or Like "LU*" Or Like "ME*" Or Like "MK*" Or Like "OX*" Or Like "PO*" Or Like "RG*" Or Like "RH*" Or Like "SG*" Or Like "SL*" Or Like "SO*" Or Like "SS*" Or Like "TN*" or br* or cr* or da* or e#* or ec* or en* or en* or ha* or ig* or kt* or n#* or nw* or rm* or se* or sm* or sw* or tw* or ub* or w#* or wc* or wd* or Like "DH*" Or Like "DL*" Or Like "HG*" Or Like "HU*" Or Like "LS*" Or Like "NE*" Or Like "SR*" Or Like "TS*" Or Like "WF*" Or Like "YO*" or Like "BB*" Or Like "BD*" Or Like "BL*" Or Like "CA*" Or Like "CH*" Or Like "CW*" Or Like "FY*" Or Like "HD*" Or Like "HX*" Or Like "L#*" Or Like "LA*" Or Like "M#*" Or Like "OL*" Or Like "PR*" Or Like "SK*" Or Like "WA*" Or Like "WN*" or Cb* or co* or de* or dn* or ip* or le* or ln* or ng* or nr* or pe* or s#* or B#* or cv* or dy* or hr* or nn* or st* or tf* or wr* or ws* or wv* or Like "BA*" Or Like "BH*" Or Like "BS*" Or Like "DT*" Or Like "EX*" Or Like "GL*" Or Like "PL*" Or Like "SN*" Or Like "SP*" Or Like "TA*" Or Like "TQ*" Or Like "TR*" or like bt* or Ab* or dd* or dg* or eh* or fk* or g#* or hs* or iv* or ka* or kw* or ky* or ml* or pa* or ph* or td* or ze* or Like "CF*" Or Like "LD*" Or Like "LL*" Or Like "NP*" Or Like "SA*" Or Like "SY*" or like “JE*” or like “GY*” or like “IM*” ));
would be most grateful for any assistance, im quite new to automatic procedures so please explain in simple terms!!
thanks