Search results

  1. N

    Solved How do I add a zero to a number within a databricks Table using SQL

  2. N

    Solved How do I add a zero to a number within a databricks Table using SQL

    Ok Thanks that does work on databricks sql
  3. 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...
  4. N

    Solved How to setup conditional formatting on a form

    Thanks that is working fine now :)
  5. 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?
  6. N

    Solved Highlight Duplicated Customer in a form

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

    Solved Highlight Duplicated Customer in a form

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

    Solved Highlight Duplicated Customer in a form

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

    Solved Highlight Duplicated Customer in a form

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

    Solved Highlight Duplicated Customer in a form

    The sourcerow is the Table called Customer_main
  11. N

    Solved Highlight Duplicated Customer in a form

    not sure how to do that :(
  12. N

    Solved Highlight Duplicated Customer in a form

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

    Solved Highlight Duplicated Customer in a form

    Its on a sub form - conditional formatting on the field Service_Number
  14. 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
  15. N

    Solved Merge Records together with the same data in both records

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

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

    Thanks that did the job :)
  18. 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
  19. N

    Solved Query to show difference in telephone and email stored in a table

    @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...
  20. 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...
Back
Top Bottom