Welcome to SPN

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

Sign Up Now!

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
    >
     

Share This Page