Creating field using Expression Builder

[Gavx]

I am using expression builder to specify a field in a report but it is acting more like a filter. How to fix this?

So I have a report based on a query. However I want to add a field that is not in the query but is in a related table - called tblAgent.

So using expression builder I select the tblAgent in Expression Elements and then select the field from this table. This creates the expression =[Agent]![AgentAddress] however when I try to run the report it asks for a Agent parameter?
Do I need to go back to reports 101?

 

[ypma]

Could you not include your related tblAgent along with the other table in the query ,then you would have the fields you require , Just a thought not a solution

Regards Ypma