Report thinks it is a parameter query. How do I fix it?

[rccline]

I am trying to create a report that is based on a query.
For the control, I want a control that prints FirstName " " LastName.

In design view, I enter this into the control source of the property fields:

=[QryContacts]![FirstName] And [QryContacts]![LastName]

When I change to report view, I am prompted for QryContacts ParameterQuery.

If I leave the Parameter query blank and click OK, I get a report with error.

What is the problem?

Thanks.
Robert

 

[sko]

=[FirstName] & " " & [LastName]

As an alternative, you could add an extra field in your query that concatenates the first name and last name (you don't have to include the individual fields as columns in the query)

Name:[FirstName] & " " & [LastName]

Then, bring the name field into your report.

HTH

 

[rccline]

That worked. If I try and use the 'build tool, it brings in the fields structured like this: =[QryContacts]![FirstName]
...which don't work.

I'm confused. Why doesn't the build tool work?

Thanks.

Robert