#Error in every report field, using query -- query works

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that consolidates data from two tables -- The main table
carries two keys pointing to two records in another table. The query is
written and works correctly. In the report's design view, I let the
Expression Builder create the path to each field. It generates
=[qryName]![tblName.colName], which, when passed back to the field's
properties Control Source still has the brackets. Hit enter to complete the
process. Brackets remain. When I finish all 29 fields, and click on the
save icon, the brackets disappear. If I try to run the report anyway, it
asks for a parameter value, labeled with the query name (The query, when run
by itself doesn't ask for a parameter). I enter * and click OK. Report runs
with #Error in every field. Obviously, I'm missing something. Help! Jim
 
A report has a single record source. This can be a query, table, or sql
statement. Once you set this property, you should be able to view the Field
List and drag fields to your report.

You should not use the expression builder.
 
Back
Top