Recent content by deneguil

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!

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

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

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