Pivot Table Questions

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

I have two/questions/problems/pet peeves about pivot tables:

1. If I choose to have a totals column then even though in design view the
totals is on the right, when displayed it's always on the left.
Since I tend to work with climate data my columns are usually months
(1-12) with the totals being annual data. I want it on the left not as the
1st column.
2. If I create a pivot table against a query it will not let me have
[brackets] in the query to ask for input. That's a pain in the
...............
 
I assume you're talking about Crosstab queries.

1. A Crosstab query outputs the columns in the order you specify, but it
processes the Row Heading columns first left to right and then does the
Column Heading / Value. You can change the sequence of the columns in
Datasheet view. Open the query datasheet, click the column name bar to
highlight the entire column, and then drag the column to where you want it
to display. Save the query (this saves the Datasheet settings) before you
close it. Of course, the real solution is to use your query in a Report
where you can control the sequence of columns in the report design.

2. Yes, you can use parameters in a Crosstab. When you use parameters, you
should always explicitly declare them by choosing Parameters from the Query
menu in Design view. Most queries let you get by without declaring the
parameters, but Crosstab queries won't work at all unless you do so.
Declare your parameters, and your Crosstab should work.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top