Search results

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