Decimal point in Report Expression

[Valery]

Hi all,

I have a text box with the following expression:

=IIf([ENT_Mailbox]>=0,[ENT_MailboxRate],"")

The data is entered as 4.25, 5.0, 6.5 and so on in the ENT_MailboxRate.
However, I can't figure out what to put in Format or Decimal Places to the number comes out the way it was entered.

I have tried various combinations. Numbers like 4.25 come out as 4 or 4.0 in the various scenarios I tried.

Anyone as a solution? THANK YOU!

 

[JHB]

What field type is ENT_MailboxRate?

 

[Valery]

Thank you for answering!! The ENT_MailboxRate correspond to the hourly rate charged to repair or paint or... the mailbox.

In the table, the field =

Size: Double
Format: General Number
Decimal Places: 2

And it works fine in a report if I don't need to insert it into an expression, which I do.

Hope these were the answers you would looking for...

 

[JHB]

..
Hope these were the answers you would looking for...

Yes it was.

..
And it works fine in a report if I don't need to insert it into an expression, which I do.

It should work, so create a new control an put in the same expression.

 

[Valery]

Created a new text box, re-keyed the expression - left Format blank and decimal place at Auto. It returns 4. Should return: 4.25. Am I missing something from your suggestion?

FYI: using MS Access 2010

 

[JHB]

Could you post a stripped down version of your database, a table with a few sample data in it, and the report.

 

[Valery]

I will try - it is a large database. TY

 

[JHB]

Then create a new database and put in a table with some sample data and a report.

 

[Valery]

Here is a sample. The data in the table is 4.25 but shows as 4 in the report. Thank you!

 

[JHB]

The problem is you've "forgotten" the values you've in the table and which conditions you've set up.

 

[Valery]

How stupid of me! Thought the 4.25 was coming out as 4. Very sorry - super thank you for looking into this and figuring it out!