I have a report that is looking at a table.
1 item on the report needs to get a calc'd field in a query. But I am am
having problems pointing the record source to the query. Expression builder
in Access 2003 insists on building the following expression:
=[Query3]![Counts] which results in an error on the report.

Help !!!!

Thx in advance for the help.

On Wed, 31 Oct 2007 13:40:03 -0700, Steve wrote:

> I have a report that is looking at a table.
> 1 item on the report needs to get a calc'd field in a query. But I am am
> having problems pointing the record source to the query. Expression builder
> in Access 2003 insists on building the following expression:
> =[Query3]![Counts] which results in an error on the report.
>
> Help !!!!
>
> Thx in advance for the help.

Does the query have a field named "Counts" and returns just 1 value?

=DLookUp("[Counts]","Query3")

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Yes it does and it returns 35 values.

"fredg" wrote:

> On Wed, 31 Oct 2007 13:40:03 -0700, Steve wrote:
>
> > I have a report that is looking at a table.
> > 1 item on the report needs to get a calc'd field in a query. But I am am
> > having problems pointing the record source to the query. Expression builder
> > in Access 2003 insists on building the following expression:
> > =[Query3]![Counts] which results in an error on the report.
> >
> > Help !!!!
> >
> > Thx in advance for the help.
>
> Does the query have a field named "Counts" and returns just 1 value?
>
> =DLookUp("[Counts]","Query3")
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>