Microsoft KB Archive/120129

{|
 * width="100%"|

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

 * }

Q120129

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

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

'[ . ]' 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]

You can then refer to these aliases in your report. The following examples demonstrates how to sum the aliases:

  =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.