I have a table with a single record that contains checkboxes. They are
checked off if certain events have occured. In my query, I want to base the
calculation of an average score on whether certain events in the other table
are checked off. I suppose this is possible via a form, but I want to use
queries/tables so the output can be used in forms or reports. How can I
refer to the fields in the table with the checkboxes? If I try to include it
in the query without a join, I get the 'ambiguous outer join' error. I have
looked quite a bit on the web to no avail.