Access2000 - format 6152346.00 to 6.15 ??? 
Author Message
 Access2000 - format 6152346.00 to 6.15 ???

Right off hand,
Int(6152346.00 / 1000) / 100
should do it. Is there something you're not telling us?

--
Wayne Morgan
Microsoft Access MVP


Quote:
> how do i format 6152346.00 to 6.15 in access 2000 vba???

> thanks.



Sat, 11 Sep 2004 12:31:26 GMT  
 Access2000 - format 6152346.00 to 6.15 ???
Bart,

Maybe I'm being a bit simplistic, but wouldn't
Format(6152346.00/10^6,"#.00") do the trick?

- Graham R Seach MVP


Quote:
> how do i format 6152346.00 to 6.15 in access 2000 vba???

> thanks.



Sat, 11 Sep 2004 12:38:42 GMT  
 Access2000 - format 6152346.00 to 6.15 ???
yes, thanks.
Quote:
>-----Original Message-----
>Bart,

>Maybe I'm being a bit simplistic, but wouldn't
>Format(6152346.00/10^6,"#.00") do the trick?

>- Graham R Seach MVP



>> how do i format 6152346.00 to 6.15 in access 2000 vba???

>> thanks.

>.



Tue, 14 Sep 2004 04:49:30 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. A big tip for all using Crystal with Btrieve 6.15

2. ODBC drivers for Btrieve 6.15 needed

3. Btrieve 6.15

4. VB and Btrieve 6.15

5. VB3 or VB5 / Btrieve - How to connect to Btrieve 6.15 Files

6. VB3 or VB5 / Btrieve - How to connect to Btrieve 6.15 Files

7. Betrieve (6.15) and VB6

8. Access2000 Format

9. VB6 to Access2000 Unrecognized Database Format

10. Access2000 and VB6 Format problem

11. Unrecognized Format with VB/Access2000

12. access2000 unrecognised data format

 

 
Powered by phpBB® Forum Software