Please explain Error Message Expr002

[Anna LK]

I'm using Office 2000.

I've just created a query. When I run it I get Expr002 as one of the column
headings. Any ideas what this means?

Thanx

 

[Golfinray]

It probably means you have one field entered twice or you have an error in a
criteria.

 

[Tom van Stiphout]

On Fri, 6 Feb 2009 05:48:06 -0800, Anna LK <Anna
(e-mail address removed)> wrote:

It would help if you posted the SQL. Look carefully at the query in
design view and you should be able to find it. More than likely you
have an expression (e.g. Price * Quantity) without a column name (e.g.
Extended Price).

-Tom.
Microsoft Access MVP

 

[Stefan Hoffmann]

hi Anna,

I've just created a query. When I run it I get Expr002 as one of the column
headings. Any ideas what this means?

Each column/field in a query must have a name. When you enter an
expression of any kind into one of the columns of the query designer and
you don't name it by preceding it with a

NameOfField: [egNumberField] * 2

then the designer creates this name automatically while the query is
saved. So Expr002 is not an error message.

Open your query in design mode, search for columns containing any kind
of expressions and assign them a name.


mfG
--> stefan <--