Cross-tab query

[Guest]

Why is it that, once you create a cross-tab query and try to create another
column based off the information that the crosstab created, access cannot
recognize it's own field. So, if I create a column to sum all of the
commission data for 2007 and access (in design mode) calls these columns
"Year 2007" and "Year 2006", I can't build a column the subtracts one from
the other. They tell me that access cannot recognize either of them as valid
expressions.

 

[Guest]

The columns aren't generated until you run the query. Depending on what you
want to accomplish there may be good alternatives. The nastiest alternative
might be to create a new query based on your crosstab and perform your
calculation there.

If you want potentially better alternatives, you need to provide more
information including the SQL view of your crosstab.

 

[George Nicholson]

Since the field names have spaces, enclosing them in brackets is mandatory:
YTYChange: [Year 2007] - [Year 2006]

HTH,