Really basic question about Queries

[Guy Fletcher]

I'm using Access 2003, and my query has a couple of "working" columns,
i.e. there's a calculation and it inserts "Expr1:" and so on. As I
don't really need them to be displayed in the results, I UNticked the
"show" option in those columns. However, when I did that, those
columns not only disappeared from the "Design View", but the query
wouldn't run - said "Expr1 not found" etc. Huh?!?! I recreated the
columns and it's fine. It's not crucial, obviously, but I'd still like
to know where I was wrong in my assumptions! Is "show" not what I
thought it was?

Thanks
Guy

 

[John W. Vinson]

I'm using Access 2003, and my query has a couple of "working" columns,
i.e. there's a calculation and it inserts "Expr1:" and so on. As I
don't really need them to be displayed in the results, I UNticked the
"show" option in those columns. However, when I did that, those
columns not only disappeared from the "Design View", but the query
wouldn't run - said "Expr1 not found" etc. Huh?!?! I recreated the
columns and it's fine. It's not crucial, obviously, but I'd still like
to know where I was wrong in my assumptions! Is "show" not what I
thought it was?

Thanks
Guy

Please post the SQL of the query. It would seem you're using Expr1 somewhere
else. It may not be necessary to do so - you can recapitulate the calculation
in another calculated field, in fact you often must do so since Access often
won't let you base one calculation on a previous calculation.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com