bank check file

[margaret]

We send a file to our bank everyday that states what checks are written and
for how much. The format must be very exact and it has to be a text file.
So my thought was to take my table which has the chno, ckamt, chdate and
create this file using a query then export to a text file. The field for
check amount must always be 12 characters long. So $50.00 would be
000000005000, $2525.75 would be 000000225275, etc. My brain is fried... I
can't figure how to get the leading zeros and the dollar to always be 12
characters.

Any ideas?

 

[ND Pard]

Because you do NOT want the decimal place shown, the amount needs to be
multiplied by 100.

Try this in the Field line of your query grid:

Format([ckamt]*100,"000000000000")

Good Luck.

 

[margaret]

Wow ... you're also very good. That worked perfectly. Thanks so much.

Because you do NOT want the decimal place shown, the amount needs to be
multiplied by 100.

Try this in the Field line of your query grid:

Format([ckamt]*100,"000000000000")

Good Luck.

We send a file to our bank everyday that states what checks are written and
for how much. The format must be very exact and it has to be a text file.
So my thought was to take my table which has the chno, ckamt, chdate and
create this file using a query then export to a text file. The field for
check amount must always be 12 characters long. So $50.00 would be
000000005000, $2525.75 would be 000000225275, etc. My brain is fried... I
can't figure how to get the leading zeros and the dollar to always be 12
characters.

Any ideas?