Search results

  1. N

    Solved Mass Importing Txt Files

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

    Solved Convert a text string date to dd/mm/yyyy

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

    Count the number of rows with a number?

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

    Solved Remove text Prefix from a number

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

    CountIF

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

    How do I i create a new table of data with set fields from an imported text file that is just a string of text..

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

    Solved Get the latest date from 3 fields

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

    Solved Query date or is null not working

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

    Solved How do I add a zero to a number within a databricks Table using 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...
  10. N

    Solved How to setup conditional formatting on a form

    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?
  11. N

    Solved Highlight Duplicated Customer in a form

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

    Solved Merge Records together with the same data in both records

    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?
  13. N

    Solved Create Query to add "Month" using the record date file "Order_Date"

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

    Query to correct telephone numbers mobile and then landline

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

    Solved Update Telephone Numbers

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

    Solved Create a new table using ..

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

    Solved How can i rename these files to a unique name?

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

    Query to Show oldest and newest date

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

    Solved #Error on shortening postcode if no postcode is present

    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),"")
  20. N

    Solved Fixing #ERROR when no data is within the field when using this

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