MS Access

Posted on 2012-09-06
Last Modified: 2012-09-06
To whom it may concern,

When I am building my query in design view, what expressions do I use such that the number that I am outputting, is formatted as "currency", but has no decimals?

Question by:maroulator
    LVL 41

    Expert Comment

    try with:

    format(yourcolumn, "$#,##0")
    LVL 47

    Accepted Solution

    But that will display it as a text column.

    If you highlight the column in the query grid, and display the properties for that column, you should be able to set the format property to Currency, and set the Decimals to 0.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now