Please explain Error Message Expr002

A

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
 
G

Golfinray

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

Tom van Stiphout

On Fri, 6 Feb 2009 05:48:06 -0800, Anna LK <Anna
[email protected]> 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
 
S

Stefan Hoffmann

hi Anna,

Anna said:
I've just created a query. When I run it I get Expr002 as one of the column
headings. Any ideas what this means?
Click to expand...
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 <--
 
Top