Calc'd Field on Report

S

Steve

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.
 
F

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.
Click to expand...

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

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

Steve

Yes it does and it returns 35 values.

fredg said:
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.
Click to expand...

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

=DLookUp("[Counts]","Query3")
Click to expand...
 
Top