#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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Invalid bracketing of parameter name 1
Can't create a report from my query in Access 1
IIf in a report based on select query -- problem w/parameters 2
Report Update Fields 0
Access Access Report Works on One Machine but not Another 3
Reference controls on a dialogue form as the parameters 1
Using a query as base for report 1
crosstab query report with parameter 7

Back
Top