Search results

  1. E

    select records VBA/SQL with sum

    I'm doing my happy dance! It worked. Thanks for all you help!!!!!
  2. E

    select records VBA/SQL with sum

    Ignore the SQL earlier in this post - I've done a gazillion SQL's to try to make this work, and the one I listed above is just one of many failures. The secret code I need is how to select records that have either used all of their purchased hours (ie. (SUM(HoursLogged) - HoursPurchased) <=0 OR...
  3. E

    select records VBA/SQL with sum

    Yes, I agree about moving records to another table, and I will change that design. However, my main problem is that I have not been able to flag an account as archived. There are two conditions that can render an account inactive. Either their ExpireDate has passed, or they have consumed all...
  4. E

    select records VBA/SQL with sum

    Thanks for the feedback. Let's try a different approach since I've been all over the map trying to learn how to do this. So, I have two tables, Customer, and CustomerLoggedHours. The business scenario is a customer buys block time (on a simulator). The MS Access system allows us to set up a...
  5. E

    select records VBA/SQL with sum

    I have two tables in an Access 2016 application: Customer, and CustomerLoggedHours. This is a one to many relationship. I want to select records based on the sum of a field value in the detail table. I have tried several approaches, but none has worked. I get the error 3096 - cannot have an...
  6. E

    Hello from Eisa

    I've been working on a couple of new Access solutions, and I seem to come across a lot of questions.
Back
Top Bottom