Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


MS Access

Posted on 2012-09-06
Medium Priority
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

ID: 38373756
try with:

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

Accepted Solution

Dale Fye earned 2000 total points
ID: 38373883
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

572 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