Search results

  1. D

    Return 0 for SUM if no join was possible

    I can't believe it was such a simple fix, it really has been a while since the last time I used different joins in SQL I am quite embarrassed I forgot about them. Nonetheless thank you very much!
  2. D

    Return 0 for SUM if no join was possible

    Hello, I am a bit stuck with designing a specific query. Basically I have a table to with objects called work units and another table for people to book hours on said work units. I want to be able to sum up all the hours booked for a work unit. So I have written this query : SELECT...
  3. D

    Insert entry in table with only default values

    My first attemps works with MySQL last time I tried it. So I would have to give the value for one field for all of the others to correctly use their default values
  4. D

    Insert entry in table with only default values

    Hello, I am very new with using Access as I come more from a pure SQL background. I have been having trouble with inserting into a table using only its default values. I have a table with several Yes/No fields and each of these fields have the default value set to `=No` in the table creation...
Back
Top Bottom