ACC1x: "...Isn't a Valid Parameter Name" Err Msg Running Report

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you print or preview a report, you receive the error message:

   '[<tablename>.<fieldname>]' isn't a valid parameter name

CAUSE

You used the Groups/Totals Report Wizard to create the report, and either the report's record source is a multiple-table query containing identical field names (for example, Orders1.Order Amount and Orders2.Order Amount), or you are summing two fields with identical names in your report [for example, =Sum(Orders1.Order Amount) and =Sum(Orders2.Order Amount)].

RESOLUTION

Use aliases in the underlying query to avoid duplicate field names. For example, use the following expressions to create aliases called Expr1 and Expr2:

   Expr1: [Orders1].[Order Amount]

   Expr2: [Orders2].[Order Amount]

   =Sum([Expr1])

   =Sum([Expr2])

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 17, "Report Basics," pages 400-401

Microsoft Access "User's Guide," version 1.1, Chapter 17, "Report Basics," pages 404-405