Welcome to SPN

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

Sign Up Now!

calculate cost per unit for inventory please show how query? or T

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

  1. distance

    distance
    Expand Collapse
    Guest

  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013
    Datawind's Sunseet Singh Introduces Ubislate: Aimed at the Cost-Conscious World Sikh Personalities Jan 12, 2014
    Sikh Coalition Major Retailers Remove Turban and Beard Costume Sikh Organisations Oct 1, 2013
    USA Osama Bin Laden Halloween Costume Removal Demanded By Sikh Advocacy Group In Letter To Walmart And A Breaking News Sep 28, 2013
    News The Cost and the Price of Loyalty (Khalsa News) Punjab, Punjabi, Punjabiyat Aug 1, 2011

  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Yes, of course this can easily be done.

    But what information do you have? And what are the fields in your table?

    Let's say you know the total price paid and the number of units bought, the
    cost per unit is simply a division:

    [CostPerUnit] = [TotalPaid] / [UnitsPurchased]

    Is this what you mean?
    "distance" <distance@discussions.microsoft.com> wrote in message
    news:38076ACB-C912-4140-84B8-C8E3813E70A1@microsoft.com...
    > Please send me an email to mrunkowski@hotmail.com


    Why? The whole idea of a newsgroup is that the whole community benefits
    from the answers posted here.

    > Thank you.

    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand
     
  4. distance

    distance
    Expand Collapse
    Guest

    Re: calculate cost per unit for inventory please show how query? o

    Graham,

    Can I do the calculation in a table or form, how do I do it???? Just started
    using access and am not sure how to calculate , will appreciate any help.
    Mrunkowski@hotmail.com

    Thanks

    "Graham Mandeno" wrote:

    > Yes, of course this can easily be done.
    >
    > But what information do you have? And what are the fields in your table?
    >
    > Let's say you know the total price paid and the number of units bought, the
    > cost per unit is simply a division:
    >
    > [CostPerUnit] = [TotalPaid] / [UnitsPurchased]
    >
    > Is this what you mean?
    > "distance" <distance@discussions.microsoft.com> wrote in message
    > news:38076ACB-C912-4140-84B8-C8E3813E70A1@microsoft.com...
    > > Please send me an email to mrunkowski@hotmail.com

    >
    > Why? The whole idea of a newsgroup is that the whole community benefits
    > from the answers posted here.
    >
    > > Thank you.

    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    >
    >
     
  5. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Re: calculate cost per unit for inventory please show how query? o

    You're not being very free with your information are you :)

    You have not answered my fundamental questions:

    >> What data do you have? And what are the fields in your table? <<


    Let's say you have a Purchases table and it has fields such as:
    InventoryID (identifying what was purchased)
    PurchaseDate
    SupplierID (identifying whom you bought from)
    TotalPaid
    UnitsPurchased

    Then you could create a query based on this table with a calculated field.
    In the query grid it would look like this:
    CostPerUnit: [TotalPaid] / [UnitsPurchased]

    Or you could create a form based on your table with a calculated control
    (textbox). The ControlSource property of the textbox would look like this:
    = [TotalPaid] / [UnitsPurchased]

    Seriously though, if you want anything more than general help, we can't give
    it to you if we need to guess what your table structures are like!
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand


    "distance" <distance@discussions.microsoft.com> wrote in message
    news:EF0FB1E1-0B3A-45F2-B3D1-586F7CA72EB6@microsoft.com...
    > Graham,
    >
    > Can I do the calculation in a table or form, how do I do it???? Just
    > started
    > using access and am not sure how to calculate , will appreciate any help.
    > Mrunkowski@hotmail.com
    >
    > Thanks
    >
    > "Graham Mandeno" wrote:
    >
    >> Yes, of course this can easily be done.
    >>
    >> But what information do you have? And what are the fields in your table?
    >>
    >> Let's say you know the total price paid and the number of units bought,
    >> the
    >> cost per unit is simply a division:
    >>
    >> [CostPerUnit] = [TotalPaid] / [UnitsPurchased]
    >>
    >> Is this what you mean?
    >> "distance" <distance@discussions.microsoft.com> wrote in message
    >> news:38076ACB-C912-4140-84B8-C8E3813E70A1@microsoft.com...
    >> > Please send me an email to mrunkowski@hotmail.com

    >>
    >> Why? The whole idea of a newsgroup is that the whole community benefits
    >> from the answers posted here.
    >>
    >> > Thank you.

    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >>
    >>
     

Share This Page