export specified text formats access97

[kflick]

I have a requirement to export a 9 digit number to a text file with leading zeros and no decimals

also a upc code as follows X XXXXX XXXXX X
and scc code x XX XXXXX XXXXX

i got the exporting working fine with the exception of the formatting

i tried an input mask
but maybe i don't know what I'm doing

my yahoo chat is up if any one can help (thnder_mutt)

thanks in advance

 

[The_Doc_Man]

You don't want the input mask. In a SELECT query, get all of the fields you want to export. Now, for the ones with special output formats, you want to use the FORMAT function with your field rather than the raw field name yourself.

To find out how to format exactly what you wanted, look up Format function in Help. Then follow the topic that leads to user-defined text formats.

 

[kflick]

I generally use the help section before I ask for help.

If the answer were there I wouldn't have wasted my time or yours.

I did look in the help section again and although my result screen now demonstrates the proper format the export dose not.

I don't want to use code to accomplish this task if i can avoid it I was hoping that the export utility could be trained to accept the data in a format that is acceptable.

If code is an absolute requirement then so be it.

 

[kflick]

sorry if I sound like an ass on my last reply . This is just bugging me. this rtf file shows the proper format ... ooops no rtf allowed sorry