saving a report to a text file without decimals

[tgavin]

I have a report that needs to be exported to a text file in a specific format
without decimal places. It's a list of checks for reconciliation purposes. In
Access, I have created the report. Currently what the client is doing is
opening the report, taking it to word, using replace to get rid of the
decimal places, then saving it as a text file to email to the bank.

I would like to automate the process so that it save sot a specific folder
ready to be uploaded. I have a couple of problems...

I don't know how to get rid of the decimal points within Access

The only way I know to take it to Word is with the DoCmd. DoMenuItem but
since I am developing this in 2010 for use in 2007 until 2010 is available, I
am reluctant to use it. (This is an access 2 db that was never upgraded and
can not be opened beyond access 97 and I don't want to build in similar
problems.)

When the report opens up in Word and is saved as a text file, it creates an
extra line where the page break is and it has to be manually removed. The
report is 45 pages long !

Help on any or all of these problems would be greatly appreciated.

Thanks
Terri

 

[Allen Browne]

Terri, are we talking about cents here (2 decimal places)?
So if the Amount column contains 12.95 you want it printed as 1295?

If so, just create a query, and multiply the field by 100. Then export the
query. The Field row in query design will look like this:
100 * [Amount]

 

[tgavin]

Thanks you. Kinda feel dumb with that one...That I can easily do. Any ideas
on the other problems???

Terri

Terri, are we talking about cents here (2 decimal places)?
So if the Amount column contains 12.95 you want it printed as 1295?

If so, just create a query, and multiply the field by 100. Then export the
query. The Field row in query design will look like this:
100 * [Amount]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that needs to be exported to a text file in a specific
format
without decimal places. It's a list of checks for reconciliation purposes.
In
Access, I have created the report. Currently what the client is doing is
opening the report, taking it to word, using replace to get rid of the
decimal places, then saving it as a text file to email to the bank.

I would like to automate the process so that it save sot a specific folder
ready to be uploaded. I have a couple of problems...

I don't know how to get rid of the decimal points within Access

The only way I know to take it to Word is with the DoCmd. DoMenuItem but
since I am developing this in 2010 for use in 2007 until 2010 is
available, I
am reluctant to use it. (This is an access 2 db that was never upgraded
and
can not be opened beyond access 97 and I don't want to build in similar
problems.)

When the report opens up in Word and is saved as a text file, it creates
an
extra line where the page break is and it has to be manually removed. The
report is 45 pages long !

Help on any or all of these problems would be greatly appreciated.

Thanks
Terri

.

 

[Allen Browne]

Thanks you. Kinda feel dumb with that one...That I can easily do.
Any ideas on the other problems???

Are you referring to your other posts?

I assumed the rest of the story in this one (about transferring into Word)
was relevant only because you were using that approach to get rid of the
decimal points.