Search results

Thanks added that getting another error now on

Ok thank you for sharing, i am getting a run time error using this code..

I am looking for a better way to import txt files rather than me having to select the file and then import all the files are within 1 folder

Thanks all i got it working using RealDate: DateSerial(Left([T_Date], 4), Mid([T_Date], 5, 2), Right([T_Date], 2)) 20231130 = 30/11/2023 :)

Hwllo, so i am trying to confirm a date string and format as date 20231129 would be 29/11/2023 what's the best way to confirm via query

I am trying to get this working i have a pivot that is showing at the moment three month columns. I want to count the number of rows within the pivot that have data which is a number =COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals) =COUNTIF(R10:R150000, "<>")-1...

ok thanks got it working now using AccountRef: Mid([Account_No],5)

Thanks how would i use this in the query?

Its always the same and position

Hi So i need to remove the prefixed number from "ACC/0014471211" to "0014471211" whats the best way to do this with a query?

how do i copy this formula to all rows =COUNTIF(A:A,A112911) if i drag it it changed the row number =COUNTIF(A:A,A112912) =COUNTIF(A:A,A112913) =COUNTIF(A:A,A112914) =COUNTIF(A:A,A112915) and so on..

Thanks all so i have now imported the file and have set the specification imported a test file and looks good so thanks got it sorted now for the formatting :)

around 350k

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); :)