Cross-tab query

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

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.
 
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.
 
Since the field names have spaces, enclosing them in brackets is mandatory:
YTYChange: [Year 2007] - [Year 2006]

HTH,
 
Back
Top