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
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