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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
-----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.
 
Thank you. I will give this a try then.

SM Teo said:
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.
 
Jeff Boyce said:
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.

--
 
Back
Top