Calc'd Field on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 31 Oct 2007 21:40 GMT

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.

Reply to this Message

fredg - 31 Oct 2007 21:53 GMT

> 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
[quoted text clipped - 5 lines]
>
> Thx in advance for the help.

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

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

Signature

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

Reply to this Message

Steve - 01 Nov 2007 00:23 GMT

Yes it does and it returns 35 values.

> > 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
[quoted text clipped - 9 lines]
>
> =DLookUp("[Counts]","Query3")

Reply to this Message