Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

Access 2007 Formating $Values to Text

In an Access 2007 Query I need to take the currancy format of $3060.00 and convert it to a text value of 00000306000. I also need to take the number such as 23.50 and convert it to text as 002350.
1 Solution
Patrick MatthewsCommented:
SELECT SomeField, Format(SomeField * 100, "000000") AS Formatted
FROM SomeTable
DominicConstableAuthor Commented:
You Da Man

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now