Query with different dates 2

[davmold]

Hello, I am new to access.

I have imported a table that contains parts, price and the date they were sold. so my data looks like this

Part Number Price Date

A123 $10 05/01/2007
A123 $25 03/02/2007
BC12 $05 03/05/2007
BC12 $05 03/06/2007
BD34 $15 06/12/2007
BD34 $15 06/14/2007


I am trying to build a query that gives me the part number and the total amount for each month

Part Number Price Jan Feb March Apr etc.

in my query I have tried to take the date field and put a
Between #1/1/2007# And #1/31/2007# for Jan this works but if on the next colum I try Between #2/1/2007# And #2/28/2007#

I get nothing

Help!!! Please!!!


Thank you

 

[PHV]

I'd try to follow the CrossTab query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davmold]

please forgive my ignorance but I only have create query in desing view and Create query by using wizard. I tried the Create Query by using Wizard and did not see the CrossTab

 

[VRoscioli]

In the Queries pane, press the New... button. Select Crosstab Query Wizard from the list that appears.


-V

 

[davmold]

Ok I got it but now I get

Item Number 06/01/2007 06/3/2007 07/01/2007 0705/2007 A123 $05 $10 $05 $15

how could I put the moths together Like this

Jun July
A123 $15 $20

 

[davmold]

I got it!!!
Ok here is what I did

Part Number Price Date Month

A123 $10 05/01/2007 5
A123 $25 03/02/2007 3
BC12 $05 03/05/2007 3
BC12 $05 03/06/2007 3
BD34 $15 06/12/2007 6
BD34 $15 06/14/2007 6

then and did it by month

part 3 5 6

A123 $25 $10



Thank you for guiding me in the right direcction