Results 1 to 6 of 6
  1. #1
    bonnielynnw is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2016
    Location
    Howland, Maine
    Posts
    15

    Question Need Currency format for expression...

    Hi there!

    It's been a few years but now retired and trying to work with Windows 7 and no support. I have a field on my report: =IIf([ShippingTotalCharge]>0,"Shipping Charges - " & [ShippingTotalCharge],"") and want the [ShippingTotalCharge] to display as currency. Now it just says 12 and I want $12.00. I can find expression help but no examples.

    I would really appreciate an example of how to add it.

    Thank you very much for your time!

    Bonnie

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the query design, put cursor on that field,
    properties,
    set format = currency

    in a report,
    format the textbox to currency.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If that doesn't work (and because it's text I doubt it will), try

    =IIf([ShippingTotalCharge]>0,"Shipping Charges - " & Format([ShippingTotalCharge], "Currency"),"")
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    bonnielynnw is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2016
    Location
    Howland, Maine
    Posts
    15
    Exactly! Thank you so very much! I'm amazed at how much I've forgotten!

  5. #5
    bonnielynnw is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2016
    Location
    Howland, Maine
    Posts
    15
    I appreciate your response but I needed the expression formatted not the field (text).

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Listbox currency format
    By princess12 in forum Access
    Replies: 9
    Last Post: 04-14-2015, 03:49 PM
  2. Replies: 2
    Last Post: 03-27-2013, 11:03 AM
  3. Format two fields in a Union Query as Currency
    By alansidman in forum Queries
    Replies: 1
    Last Post: 12-14-2012, 12:41 PM
  4. Custom Currency Format
    By Ichigo in forum Access
    Replies: 3
    Last Post: 04-26-2011, 03:34 AM
  5. Replies: 2
    Last Post: 03-23-2011, 11:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums