Disable rounding in calculated field

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Forms Programming / June 2007

Disable rounding in calculated field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D. M. - 11 Jun 2007 14:36 GMT

Hi,

I have a report with a calculated "Total" field (totals the invoice subtotal
plus calculated taxes field). This field is currently set as currency. Can
I set the field to NOT round up?

Your help is appreciated.

Reply to this Message

Arvin Meyer [MVP] - 11 Jun 2007 15:12 GMT

A currency field is accurate to 4 decimal places and will display that many
places if you set it to 4.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi,
>
[quoted text clipped - 5 lines]
>
> Your help is appreciated.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.