Search results

Thanks for your reply, the data doesn't have any field headers its just a string like shown above so all in one field table labelled Data

So i need to break up a report that is provided in a continued string of data.. A1215455545444444842121212121212121TTTRTR2TR2TY2212121212212122121 The data will need to be broken out as following.. Record type String 1 Always "A" Supplier ID Numeric 5 XXX01 where XXX is the 3-digit...

Ok thanks got that all working now using that suggested link method Happy days!

So i now need to have some code to get the latest date from three possible fields Field names are Phone Email Text, this is what i am looking for as the outcome Phone Email Text Latest Contact 12/05/2023 21/10/2023 21/10/2023 01/11/2023 31/10/2023 01/11/2023

Thank you that did the job :)

So i am trying to bring back in a query the results of all call made after another date field or is null, but its only bring back null records, even though we do have calls with dates i am using "Contact_Date" >=[Start_Date] Or is null

Got it working the correct code is: UPDATE Test table name SET IID = CONCAT('0', IID); :)

Ok Thanks that does work on databricks sql

So i need to add leading zero to a set of numbers within a table that i imported into databricks from a CSV in doing so i lost the leading zeros, the format of the number should be like this 0999 0010 0009 i have 999 10 9 i tried this UPDATE Test table name SET IID = '0' + IID...

Thanks that is working fine now :)

I am looking for a way to have the form highlight any names that greater than in characters First Name <20 Surname <30 any pointers please?

thanks i got around it by creating a new table with the combined data and its all working now :)

yeah that got it working but unfortunately now the form is un-updateable

Conditional formatting i need to set on the "Service_Number" and get it to look at the new Count field and if greater than 2 turn the Text Red Expression Is ([CountOfService_Number]="2") doesn't work

Thanks so i now got that query work now, so how do i then go about highlighting the customer within the form in red using the new query i wonder

The sourcerow is the Table called Customer_main

not sure how to do that :(

Thats a good points, its just the file process is that access shows the user a final form that i wanted it to show any duplicates before the user clicks a button to create a report, but maybe thats the best way so query to run and get duplicated and then how would i show on the subform?

Its on a sub form - conditional formatting on the field Service_Number