Welcome to SPN

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

Sign Up Now!

Format results of a calculation in a query?

Discussion in 'Information Technology' started by Deseree, Nov 16, 2005.

  1. Deseree

    Deseree
    Expand Collapse
    Guest

    I have completed a calculation in a query and just need to know how this can
    be formatted to currency to be able to use in a merged document in Word?
     
  2. Loading...

    Similar Threads Forum Date
    India Indian ‘Journalist’ Slams Gurbaksh Singh Than Admits to Receiving Information from ‘Agencies’ Breaking News Dec 27, 2013
    Opinion West Punjab : Information Pool and Pictures Punjab, Punjabi, Punjabiyat Nov 18, 2013
    When Turban Turns Messenger Diaspora Finds Interesting Ways to Spread Information About Sikhi Sikh Youth Nov 10, 2013
    Story of Transformation Sikh Rehat Maryada Jul 27, 2012
    Sikhism Benti Chaupai - Keertan Format Videos Feb 11, 2012

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Deseree,

    =CCur(YourPresentCalculation)

    For example:

    LineItemTotal: CCur (([Order Details!UnitPrice])*[Quantity]*(1-[Discount]))

    See paragraph 5 in this article:
    http://www.access.qbuilt.com/html/crosstab_queries.html

    You can also use the Format function if you want, but I think using the type
    conversion function CCur is easier.


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    "Deseree" wrote:

    > I have completed a calculation in a query and just need to know how this can
    > be formatted to currency to be able to use in a merged document in Word?
     

Share This Page