Control Source

[Tom T]

In a report:

I am trying to have a text box = a # (Count) from a query,
but I keep getting a (#name?) error. Any suggestions on
how to fix this problem?

TIA,
Tom

 

[Fredg]

Tom,
How about letting us know the exact expression you are using, as well as the
name of the control in the Report.

 

[Fredg]

Tom,
I assume [Inbounds Loads Totals] is the name of the query, and it returns
just the one record.

Use a DLookUp.
=DLookUp("CountOfInbound Driver/Carrier","Inbounds Loads Totals")

Make sure the name of the control is not 'CountOfInbound Driver/Carrier'.

--
Fred

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

Here is the expression that I am trying to use.

=[Inbounds Loads Totals]![CountOfInbound Driver/Carrier]

Thanks for the help,
Tom

-----Original Message-----
Tom,
How about letting us know the exact expression you are using, as well as the
name of the control in the Report.

--
Fred

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





.