Prev: Unable to save a form or report in Access 2003.
Next: Count Function
From: Pass-the-Reality on 25 May 2010 09:04
In my queries I have formated the 2008 Net Paid column to currency. On my
report, I added the 2008 Net Paid data, but I want it to drop the cents. I
went into the format and changed decimal to 0 and it did not work. What can
I do to format the field on my report to drop the cents?
From: golfinray on 25 May 2010 09:56
In the table that is the source of the query, is the datatype currency?
--
Milton Purdy
ACCESS
State of Arkansas


"Pass-the-Reality" wrote:

> In my queries I have formated the 2008 Net Paid column to currency. On my
> report, I added the 2008 Net Paid data, but I want it to drop the cents. I
> went into the format and changed decimal to 0 and it did not work. What can
> I do to format the field on my report to drop the cents?
From: John Spencer on 25 May 2010 10:32
If you want to DROP the cents then set the control's source to
=Int([Net Paid])
or
=Fix([Net Paid])

Oh and be sure that the control's name is changed to something like txtNetPaid
to avoid a name conflict error.

If you want to round the number to the nearest whole value then use the Round
function or force the data type to long integer.
= IIF(IsNumeric([Net Paid]),CLng({Net Paid]),Null)



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Pass-the-Reality wrote:
> In my queries I have formated the 2008 Net Paid column to currency. On my
> report, I added the 2008 Net Paid data, but I want it to drop the cents. I
> went into the format and changed decimal to 0 and it did not work. What can
> I do to format the field on my report to drop the cents?
 | 
Pages: 1
Prev: Unable to save a form or report in Access 2003.
Next: Count Function