By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Query Calculation Based on Values in Another Table

P: n/a
rc
reposting from comp.database.ms-access

"rc" <ro*************@us.army.mil> wrote in message
news:ay********************@twister.tampabay.rr.co m...
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rc
I think I can do this with the dlookup() function. Didn't know this existed!
"rc" <ro*************@us.army.mil> wrote in message
news:Tz********************@twister.tampabay.rr.co m...
reposting from comp.database.ms-access

"rc" <ro*************@us.army.mil> wrote in message
news:ay********************@twister.tampabay.rr.co m...
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.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.