CREATE AN ASCII FILE 1

[kalpsv]

i WANT TO CREATE AN ASCII TEXT FILE FROM MY ACCESS97
DATABASE
IT SHOULDNOT CONTAIN ANY SPACES IN BETWEEN IN NUMBER
OR CURRENCY IT SHOULD TAKE ZEROES IN EMPTY SPACES
I DO NOT KNOW HOW TO START AND WHERE TO START
I USE CR OF VISUAL BASIC 5
PLEASE HELP ME

 

[dgillz]

IF you are saying that you want zero padded numbers, use the picture function:

Picture(totext({Numberfield},0,"&quot,"00000000&quot

This will return text such as "00000005" instead of the number 5 Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[JasonLord]

actually make it one function easier...

totext({Numberfield},"00000000&quot

will do exactly the same thing as the picture/totext function pair above...

 

[dgillz]

Jason,

I did not know that. Cool. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com