Include NULL Values - SQL Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

My SQL query tells me the number of people in attendance, per day, for a
specific date range.

But my query doesn't return dates for those days with a null value (no
people in attendance).
So I have days missing (gaps) in my calendar.

How can I modify my query to include every sequential date/date, even those
with NULL values.

Thanks
Stuart Troy
Sydney AUSTRALIA


.

Relevant Pages

  • RE: Using a subform to display and add info into table
    ... I created a query called AppendAttendanceRecords and used the INSERT SQL ... when I have the Attendance ... "Sprinks" wrote: ... >>> Each instance will have many students, and, in fact, the same students that ...
    (microsoft.public.access.forms)
  • RE: Using a subform to display and add info into table
    ... - Did you create a query by cutting & pasting the INSERT SQL statement into ... - With the Attendance form open, with a SessionID and SessionDate entered, ... >> Each instance will have many students, and, in fact, the same students that ... >> a combo box for the SessionID (with the same properties as the one on your ...
    (microsoft.public.access.forms)
  • Re: Populating the many side of a 1 to Many relationship
    ... I was wondering if a query was the way to go. ... The information relating to the Attendance fields will be unique and only ... Typically students will all be marked attending, ... On the 1 side is Yr8students and on the many side is ...
    (microsoft.public.access.modulesdaovba)
  • Re: last date in sub form
    ... tblEmployee 1 record for each employee. ... Create a query into your table. ... I would like to display only the latest ... > attendance to a particular course. ...
    (microsoft.public.access.forms)
  • Re: Querying Number of Days
    ... FROM Attendance ... "Admiral O. F. Doom" wrote: ... When people enter the lab, they sign in on a sign-in sheet. ... I have one query already that counts the number of people by day. ...
    (microsoft.public.access.queries)