Showing currency decimal values in formns

Chuck Insight

Hi All,

I designed an input query as the basis of a form. Some fields (like for pennies) are numbers that I formatted as currency and specified as 2 decimal places. However, it appears to round down anything under 50¢, which then displays as $0.00 and appears to round up anything over 51¢, which then displays as $1.00

How can I get these to show up "Properly" in the form?

Thanks very much,
Chuck

Nov 13 '05 #1

Subscribe Post Reply

1661

Allen Browne

Open the table in design view.
Select the field that gives you this problem.
Change the Field Type to Currency.

The integer type numbers store whole numbers only.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:ucnwe.113159$xm3.2863@attbi_s21...

I designed an input query as the basis of a form. Some fields (like for
pennies) are numbers that I formatted as currency and specified as 2 decimal
places. However, it appears to round down anything under 50¢, which then
displays as $0.00 and appears to round up anything over 51¢, which then
displays as $1.00

How can I get these to show up "Properly" in the form?

Thanks very much,
Chuck

Nov 13 '05 #2

Chuck Insight

It Worked - Yipee

Thanks very much,
Chuck

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #3

Similar topics

floating or decimal for currency values

by: anagai | last post by:

hi Isnt it true that floating type can generate rounding errors if the values are rounded to like the 10th decimal. Since currency is rounded only to the 2nd decimal why must i worry about using...

MySQL Database

Unformatting currency values for updating SQLServer

by: crater | last post by:

Have any of you good folks out there got an elegant solution for unformatting currency values for writing back to SQLServer: e.g.: $10,100,200.59 to 10100200.59 but for any locale and any...

.NET Framework

Upsizing currency fields

by: Dave Stone | last post by:

This question appeared years ago in the context of Acc2K and SQL Server 7, but no replies were posted. HOWEVER!! It still seems to be a problem with Acc XP and SQL Server 2000. Surely someone has a...

Microsoft Access / VBA

Convert Currency-formatted string back to decimal

by: KB | last post by:

Hi guys, In my DataGrid I have a column that displays decimal values as currency ( I set the Data Formatting expression of that column to {0:C}). So the actual string displayed in the grid looks...

ASP.NET

format string for currency

by: John A Grandy | last post by:

i thought the following would work for currency {0:$000,000,000.00} but it is displaying ( for example ) : $000,025,368.87 i don't want the extra zeros ...

Visual Basic .NET

can't use Currency in a function declration!

by: Adrian | last post by:

Hi I want to use the following declarations but vb dotnet keeps complaining that currency can't be used because it private ? I have tried it in a module and in the declaration pare same error!...

Visual Basic .NET

Currency Math in VB.NET

by: Mitchell Vincent | last post by:

Just making sure I'm not missing the boat here, but are there any special routines for doing currency math (fixed precision stuff) in .NET? The wonderful problems of doing math on decimals tend...

Visual Basic .NET

Formatting A String As Currency

by: Scott M. | last post by:

Ok, this is driving me nuts... I am using VS.NET 2003 and trying to take an item out of a row in a loosely-typed dataset and place it in a label as a currency. As it is now, I am getting my...

C# / C Sharp

RangeVlidator Currency Minimum and Maximum value

by: =?Utf-8?B?SGlwSG9wcGVy?= | last post by:

Hi, What's the Minimum and Maximum value for RangeValidator currency type? For example form -99,999,999,999,999 to 99,999,999,999,999? -- HipHopper

ASP.NET

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice