saving a report to a text file without decimals

T

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
 
A

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]
 
T

tgavin

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

Terri

Allen Browne said:
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.


tgavin said:
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

.
 
A

Allen Browne

tgavin said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top