Expression builder in reports

[neillovell]

Can someone explain what I am doing wrong? I create a text box and go to expression builder (Control Source). I want to display the data in column TOTAL of query Emp-One, so I double click the folders at the bottom of the builder to get to the right query. In the middle window box I double click the TOTAL entry and it displays

[Emp-OneQuery]![TOTAL]

But when I do Print Preview I get #Name? displayed.

what's up?

 

[CosmoKramer]

Is "Emp-One" the RecordSource for this report?? If so, click on the drop-down for the field's ControlSource and select the field from that field list instead.......

 

[neillovell]

I want several sources for the report. Is that possible?
Emp-OneQuery, Emp-TwoQuery, and Emp-ThreeQuery