sort data by date into columns

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I have one table (Access 97)with many fields... here's
part of it:

#Impressions Completed_Date
1000 2003-04-02
50 2003-04-02
2000 2003-05-10
3000 2003-06-01
50 2003-06-05

I need a query that will SUM the #Impressions and sort by
each month into columns... like this

April May June
1050 2000 3050

Any suggestions?

Thanks.
 
Dawn said:
I have one table (Access 97)with many fields... here's
part of it:

#Impressions Completed_Date
1000 2003-04-02
50 2003-04-02
2000 2003-05-10
3000 2003-06-01
50 2003-06-05

I need a query that will SUM the #Impressions and sort by
each month into columns... like this

April May June
1050 2000 3050
Click to expand...

Check out the new query wizard and the option for Crosstab query. It does exactly
this sort of thing.
 
-----Original Message-----


Check out the new query wizard and the option for
Click to expand...
Crosstab query. It does exactly
this sort of thing.

Hi Rick
Click to expand...
I tried the Crosstab query wizard .... I couldn't get it
to work for me. I can pick the #Impressions for the rows
and select Completed_Date for the columns but this doesn't
work because I still have to select a field for the SUM
function. I know the #Impressions has to be used for the
SUM function but it isn't in the list of fields because it
is already used for the rows and you can't leave the rows
or columns blank. Am I missing something on the wizard
functionality?
 
Back
Top