Calc'd Field on Report

[Guest]

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.

 

[fredg]

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")

 

[Guest]

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
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")