Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Query Help Sought

Discussion in 'Information Technology' started by Jay, Jul 28, 2006.

Tags:
  1. Jay

    Jay
    Expand Collapse
    Guest

    Hi

    I have a table with the following fields
    - Month
    - CarID
    - Reg Plate
    - Mileage Band
    - Sale Price

    And I am trying desperately to achieve something in a query but can't.

    The table contains car sales data, as you may have gathered. What I am
    trying to do is arrange the query so that car sales in the same month for
    the same CarID, same mileage Band and consecutive plates are returned, along
    with a calculated field giving the % difference in Price.

    The 2 plates I am interested in are 2003 52 and 2003 03. I want to extract
    all instances where there are sales for the same car/same month/same mileage
    band on these plates & calculate the difference in Sale Price.

    SO let's say 3 records have same Month,CarID,RegPlate & MileageBand with a
    Reg Plate value of 2003 52.
    And there are 2 records with same month,ID,RegPlate, & MileageBand with a
    Reg Plate value of 2003 03.

    I need the query to group & average the three 2003 52 Prices, group &
    average the two 2003 03 price and give the % Price Difference in a
    calculated field.

    I'm afraid my query skills are just not up to this at the moment so would
    really appreciate any help anyone could offer. It would save me so much
    time doing it manually in Excel . As well as being an invaluable learning
    opportunity.

    Many thanks

    Jason

    I hope I've given enough details. If not please let me know. Cheers
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    see your post in other newsgroup where you posted this same question.

    --

    Ken Snell
    <MS ACCESS MVP>

    "Jay" <zeugma@toucanspam.com> wrote in message
    news:C0D3556B.4E2A%zeugma@toucanspam.com...
    > Hi
    >
    > I have a table with the following fields
    > - Month
    > - CarID
    > - Reg Plate
    > - Mileage Band
    > - Sale Price
    >
    > And I am trying desperately to achieve something in a query but can't.
    >
    > The table contains car sales data, as you may have gathered. What I am
    > trying to do is arrange the query so that car sales in the same month for
    > the same CarID, same mileage Band and consecutive plates are returned,
    > along
    > with a calculated field giving the % difference in Price.
    >
    > The 2 plates I am interested in are 2003 52 and 2003 03. I want to extract
    > all instances where there are sales for the same car/same month/same
    > mileage
    > band on these plates & calculate the difference in Sale Price.
    >
    > SO let's say 3 records have same Month,CarID,RegPlate & MileageBand with a
    > Reg Plate value of 2003 52.
    > And there are 2 records with same month,ID,RegPlate, & MileageBand with a
    > Reg Plate value of 2003 03.
    >
    > I need the query to group & average the three 2003 52 Prices, group &
    > average the two 2003 03 price and give the % Price Difference in a
    > calculated field.
    >
    > I'm afraid my query skills are just not up to this at the moment so would
    > really appreciate any help anyone could offer. It would save me so much
    > time doing it manually in Excel . As well as being an invaluable learning
    > opportunity.
    >
    > Many thanks
    >
    > Jason
    >
    > I hope I've given enough details. If not please let me know. Cheers
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page