Does anyone know what 'Expr1000' means when you get an error mess.

[Guest]

I am very new to Access and just took a basic class in it.

 

[Jeff Boyce]

Debbie

This implies that you have a LOT of expressions you are creating/calculating
in a query. Do you get the message when you are trying to use a query?

 

[Guest]

Yes, I am trying to set up a query figuring out totals and some of them
divided by others. I am working in a database created by my boss and I'm
using some of his tables, queries, etc., as models since I have to use his
tables. It is really just a learning experience. I'm not really sure of the
calculating/mathmetical language of a query yet. Thank you for the
information.

 

[SM Teo]

-----Original Message-----
I am very new to Access and just took a basic class in it.
.

Typically Expr1000 appear in your query when you have
brought in the field two time.
To get rid of this, you can either remove the extra field
or untick - not the show the field in your query.

 

[Guest]

Thank you. I will give this a try then.

Typically Expr1000 appear in your query when you have
brought in the field two time.
To get rid of this, you can either remove the extra field
or untick - not the show the field in your query.

 

[Jamie Collins]

This implies that you have a LOT of expressions you are creating/calculating
in a query.

Could be just one expression involved. If I create an expression but
do not give it an alias e.g.

SELECT MyKeyCol & MyDataCol FROM MyTable

the resulting column is given the name 'Expr1000' by default.

Jamie.

--