Results 1 to 6 of 6
  1. #1
    merrikaylee is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    5

    Access Web field formating

    I have a query that calculates currency fields (qty*unit price kind of thing). When I display them in a summary display form, there is no formatting. Where can I specify the currency format? Because it is a calculated field, there is no way that I can find, to tell access to format as currency.

    Thanks,


    Merrikay

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I haven't used web databases but you can try:

    =format(<calculated value>, "Currency")

    as the record source of the field

  3. #3
    merrikaylee is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    5
    Thanks...I had tried that without the "" around Currency, but had gotten an invalid field name error. With the "" I get the value "Currency" in the field when I run the Query.

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    How about "CCur(calc)"?

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Can you create another query that retrieves the Calculated Field first? So, your first query would have the necessary key values to retrieve the correct dataset and the calculated value. Use that first query as a subquery.

    Another function that you might want to consider is FormatCurrency()
    https://msdn.microsoft.com/en-us/lib.../gg264331.aspx

  6. #6
    merrikaylee is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    5
    Thank you everyone. This must be a Web App thing. I know that it is not the full version of Access.

    CCur(calc) gives me a "Function name that Microsoft Access can't find" message. FormatCurrency() gives me the same message.

    Anyone out there who is an expert on the Web App?

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

Similar Threads

  1. Replies: 3
    Last Post: 05-09-2016, 07:00 AM
  2. Field value formating not showing on form
    By cantord in forum Forms
    Replies: 1
    Last Post: 11-13-2012, 02:10 PM
  3. Conditional Formating for Field Before Group
    By AccessLes in forum Reports
    Replies: 9
    Last Post: 07-20-2011, 12:42 PM
  4. Conditional Formating (Report Field)
    By mlawson6128 in forum Programming
    Replies: 1
    Last Post: 03-10-2011, 11:23 PM
  5. formating field
    By slimjen in forum Access
    Replies: 9
    Last Post: 01-11-2011, 04:46 PM

Tags for this Thread

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