Don't want columns with expressions to show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 columns in a Query that contain expressions. I have created a third
column with an expression in the same query from those first 2 columns. I'd
like the first 2 columns to not appear in my Query but when I click off the
show buttons it's messes up the 3rd expression. Why is that? Thanks
 
Regi said:
I have 2 columns in a Query that contain expressions. I have created a third
column with an expression in the same query from those first 2 columns. I'd
like the first 2 columns to not appear in my Query but when I click off the
show buttons it's messes up the 3rd expression. Why is that?
Click to expand...


The Why of that is because only calculated fields in the
SELECT clause can be used in calculations in other fields.
Unchecking the Show box removes a field from the SELECT
clause (can still be used in the WHERE or GROUP BY) so it's
not available to your other calculated field.

The way around this situation is to scrap your first two
calculated fields and use their full expressions in the
third field. Another way is to leave the Show box checked
and use another query based on this query to calculate the
third field.
 
Thank you Marshall. Now I've got it.

Marshall Barton said:
The Why of that is because only calculated fields in the
SELECT clause can be used in calculations in other fields.
Unchecking the Show box removes a field from the SELECT
clause (can still be used in the WHERE or GROUP BY) so it's
not available to your other calculated field.

The way around this situation is to scrap your first two
calculated fields and use their full expressions in the
third field. Another way is to leave the Show box checked
and use another query based on this query to calculate the
third field.
Click to expand...
 
Back
Top