G
Guest
I'm trying to use the calculated value from one field in my query in another
calculated field within the same query. The first field calculates a number
for me; the second strings together the values from that field with another
(i.e. Expr2: [Field1] [Expr1]). My problem is that Access 2000 is treating
the field identifier (i.e. Expr1) as a parameter to be entered when the query
runs, though it recognizes the field taken from a table just fine. When using
the Expression Builder, Access clearly acknowledges that Expr1 is a field
name in the query, but when the expression used in Expr2 is parsed, Expr1 is
treated as a parameter (so a dialog box requesting the value of Expr1
appears).
calculated field within the same query. The first field calculates a number
for me; the second strings together the values from that field with another
(i.e. Expr2: [Field1] [Expr1]). My problem is that Access 2000 is treating
the field identifier (i.e. Expr1) as a parameter to be entered when the query
runs, though it recognizes the field taken from a table just fine. When using
the Expression Builder, Access clearly acknowledges that Expr1 is a field
name in the query, but when the expression used in Expr2 is parsed, Expr1 is
treated as a parameter (so a dialog box requesting the value of Expr1
appears).