By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Number Formattng

P: 19
Hello,

I am getting a numeric value in a query like 42.56, 89.67, 56.77, etc.
I want to format these values like 04256, 08967, 05677.

Please help !!!!!!


Thanks in advance.
Jul 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: 2
Your query column that is returning a double like 123.1 could be made to return a string like 12310 by using this on the first line of the column in the query:

ShowMe:Right("00000" & cstr(dblOriginalValue*100),5)

I'm assuming that dblOriginalvalue is however you're getting those original numeric values of 42.56, etc., and also that you aren't anticipating any value over 999.99 to be returned (or it would need to be more than 5-characters wide).

Hope this helps some.


Hello,

I am getting a numeric value in a query like 42.56, 89.67, 56.77, etc.
I want to format these values like 04256, 08967, 05677.

Please help !!!!!!


Thanks in advance.
Jul 17 '07 #2

Expert 100+
P: 634
Hi

Or pehaps


Format(42.57*100,"00000") etc.

??


MTB
Jul 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.