I have readings that need a zero added to the end then calculate a bill

[Diamond]

Hello: Every quarter I import readings from another program and calculate the bills and these totals go into a Fees table and the readings go into a Readings table. I have some readings that need a zero added to the end of the number and then I need to calculate the bill. An example is a reading that comes from another program like this: 3456. I need to add a zero like this: 34560 and then calculate the bill. I have a module with codes so it knows which accounts this needs to happen to. I don't need the zero to show in the tables, just calculate. What is the proper way to do this? I am new to Access and not too familiar with visual basic. I don't know how to proceed. Thank you.

[burrina]

You have not said whether your field is a text field or is numeric?

[Diamond]

The field is numeric in the Fees table. Field size: double. Format: currency. Decimal places: Auto
The field is numeric in the Readings table. Field size: double. No format. Decimal places: Auto

[orange]

Can you tell us about the other system, and why you have 2 systems involved? Why isn't the reading in the proper units from the start?
Can you post a copy of your database --remove anything confidential?
Better to run compact and repair, then zip the database.
I'm sure someone will look at it.

[Diamond]

I sent a message just a minutes ago, however, I don't know how to attach the database. I did find Manage Attachments and when I uploaded the file, it didn't show in the window. Sorry to be such a newbie.

[burrina]

First, compact, remove any personal information, then zip and upload in .mdb format.