bank check file

  • Thread starter Thread starter margaret
  • Start date Start date
M

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?
 
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.
 
Wow ... you're also very good. That worked perfectly. Thanks so much.

ND Pard said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top