Number formatting trouble...

  • Thread starter Thread starter Jason M Canady
  • Start date Start date
J

Jason M Canady

This is just killing me! I think that this should be an easy problem to fix
and end up swating at flies and moving the problem all around where I would
like to end up!

Here is the problem, I hope that some one can easily help me...

The underlying data for the field is:
FieldName: C
DataType: Number
FeildSize: Double
Format: Fixed
Decimals: 2
No Input Mask

I get acces to the information through a query with the following SQL:

IIf(IsNull([C]),"---",[C]) AS C1

The trouble that I am having is that if the value of [C] is an exact number
(I.E. 1.00) then the value in the query is 1 (I am loosing the decimals...
or I am getting to many (I.E. value = 1.1 query is returning 1.100002343...)
I am trying to format the number in the above IIF statement, but as of yet
have not found a useful bit of information in Microsofts help section and
cannot get the number to do what I need...

If you can please advise... I need 1.00 or 1.10 to display. I have tried
formatting the control on the report, but for some reason that is not
working as well... I am posting to both groups as I am not sure where this
proble should be attacked...

TIA Jason M Canady
 
Sorry for the post I found that I had already asked a similar question quite
some time ago and forgot the answer! I have fixed my problem.

Thanks for the time,
Jason
 
Back
Top