I need to output certain fields to a text file using access 2002.
The fields that I need to output need to be on this text file at certain points. i.e. Ref number on the first line with the end character position of the field at character position 16.
The user name need to end at character position 42. Therefore if the username is 5 digits long it will begin at character position 37. If it is 10 digits long it will begin at character position 32. The important part is the character position's that the fields end at.
If I have not explianed very well let me know.
Can anyone advice.
I know I can use the Print command but I don't know how I can make sure I get the end character positions of the fields to be correct.
Cheers in advance.
Neemi
The fields that I need to output need to be on this text file at certain points. i.e. Ref number on the first line with the end character position of the field at character position 16.
The user name need to end at character position 42. Therefore if the username is 5 digits long it will begin at character position 37. If it is 10 digits long it will begin at character position 32. The important part is the character position's that the fields end at.
If I have not explianed very well let me know.
Can anyone advice.
I know I can use the Print command but I don't know how I can make sure I get the end character positions of the fields to be correct.
Cheers in advance.
Neemi