Search results

  1. G

    Help with slow query

    I have one table with phone numbers [Phone Assignment List], and another table with phone usage transactions [Call Detail Data] I want to have a report which lists the unqiue phone numbers which appear on the transaction report but not in the phone number table. I wrote the below query which...
  2. G

    Validate overlapping time windows

    I have a form validation challenge for which I humbly request your support. I am building a database for phone bill management. Phone numbers are assigned to users for a period of time, and then the same number is assigned to a different user for another period of time. Users should be...
  3. G

    Macro condition Form Value NOT IN Table

    Hello, I have a form where a user can specify a file name and upload it. I want to prevent users from loading the same file more than one time, creating duplicate records. I am trying to prevent this with a macro using the CONDITION field. When a user loads a file for the first time, after...
Back
Top Bottom