Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query with different dates 2

Status
Not open for further replies.

davmold

IS-IT--Management
Jul 16, 2007
29
US
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'd try to follow the CrossTab query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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
 
In the Queries pane, press the New... button. Select Crosstab Query Wizard from the list that appears.


-V
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top