Query Calculation Based on Values in Another Table

I think I can do this with the dlookup() function. Didn't know this existed!


"rc" <robert.cipriani@us.army.mil> wrote in message
news:TzLtc.27707$0X2.969931@twister.tampabay.rr.co m...[color=blue]
> reposting from comp.database.ms-access
>
> "rc" <robert.cipriani@us.army.mil> wrote in message
> news:ayLtc.27697$0X2.969222@twister.tampabay.rr.co m...[color=green]
> > 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[/color]
> the[color=green]
> > calculation of an average score on whether certain events in the other[/color]
> table[color=green]
> > are checked off. I suppose this is possible via a form, but I want to[/color][/color]
use[color=blue][color=green]
> > 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[/color][/color]
include[color=blue]
> it[color=green]
> > in the query without a join, I get the 'ambiguous outer join' error. I[/color]
> have[color=green]
> > looked quite a bit on the web to no avail.[/color]
>
>
>[/color]