Search results

I am trying to get this to work in a sub form, to highlight the customers number in red and yellow background but its not working, the field in a text field DCount("*","Customer_main","[Service_Number]=" & Chr(34) & [Service_Number] & Chr(34))>1

Ok found the issue by me updating the imported data and setting any blank fields to NULL using an update query "" to NULL has cleared up the issue and its now working

So some of the data that comes from another data source has duplicated records for the same customer i need to have these combained into one query record. I have tried to use the "Unique values" but its still puling the same two records for the same customer?

Thanks that did the job :)

Looking to convert a dates 04/01/2023 to "January 23" 01/02/2023 to "February 23" and so on possible to have both i can get the month only using this Month: Month([Order_Date]) shows as month number not text

@Pat Hartman So this is working great and has been doing the job, now i have an issue so we have some accounts that have two sets of contacts like say RECORD _ID | ACCOUNT_NO SURNAME 4110 | 9944510 |Blue 4111 | 9944510...

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