Search results

So i need to run a query to correct the telephone numbers within two fields Mobile Landland due to the many data sources sometime we have a landline within the mobile field and the mobile within landline. i need to have access do a final clean-up and move the number to the correct file. so...

WORKED thanks :)

Hi So i need to update some telephone numbers and remove the prefix "44" 447999999999 and remove with "0"

Thank you yes thats sorted it all now :)

Yes thats correct the issue is that the query is not populating the TA postcodes TA8 & TA9 instead its created postcodes BS0-BS9 I think its because the Area is set as BS so the VBS is getting confused not sure If that can be corrected

@arnelgp so its throwing up some incorrect data.. example is this postcode BS BS24-29, TA8-9 results here.. its not picking up TA8-9 but creating BS0 > ID BN Expr1 Expr2 Expr3 Expr4 Expr5 Expr6 Expr7 Expr8 Expr9 Expr10 Expr11 Expr12 Expr13 Expr14 Expr15 Expr16 Expr17 Expr18 Expr19...

Wow you are a genius Loving It :)

The whole of the UK

if the number is greater than zero

Yeh i thinks its really a long shot

So i dont think its going to be possible, i need to create a new data table that has a Y or N next to each postcode... Short Postcode Delivery Availability BN1 Y BN3 Y BN45...

thanks thats done the job :)

Would like batch rename these files to something like "P1010015000_1.jpeg" and so on any suggestions pls

Hi, So i need to bring back the results to show the oldest order and the newest order date with a count on total orders for a customer fields i wish to include are: Customer_ID Order Date Need to show: Customer_ID ¦ Count Of Orders ¦ First Order Date ¦ Last Order Date 123...

Thanks thats worked :)

So i have this to shorted the postcode, which is working as long as a postcode is provided within the field, how can i get around so i dont get the #ERROR would like it just to be left blank? please? ShortPostcode: Left([PostCode],1) & IIf(Asc(Mid([PostCode],2,1))>=65,Mid([PostCode],2,1),"")

Its ok found a way Exp1: Val(NZ([ORDER_No],"0"))

Exp1: Val([ORDER_No]) How can i get the wuery to not show #ERROR when using the above for a blank entry please?

Perfect Thank You @arnelgp

Looking some some code to open a text file remove the first line and the save the txt file