Solved How to format the numbers dropping below 1 but zero?

[prabha_friend]

1 has to be 1 (No Decimals Needed)
-1 has to be -1 (No Decimals Needed)
but
1.25 has to be 1.250 (Three Decimals Need only for the values dropping below 1 but zero)

Thanks for reading. Please reply.

With Hope,
Prabhakaran

 

[prabha_friend]

To say it short, We can say like this: "How to format the positive decimal places in ms access"

 

[Gasman]

1 has to be 1 (No Decimals Needed)
-1 has to be -1 (No Decimals Needed)
but
1.25 has to be 1.250 (Three Decimals Need only for the values dropping below 1 but zero)

Thanks for reading. Please reply.

With Hope,
Prabhakaran

Since when has 1.25 been dropping below 1?
I cannot make head or tail of what you want.
Perhaps use the Int() function ?

 

[prabha_friend]

Since when has 1.25 been dropping below 1?
I cannot make head or tail of what you want.
Perhaps use the Int() function ?

Good Question. Sorry. Almost sleeping.

I just want 3 digits after the decimal separator, only if the actual value is been entered with atleast a single decimal value after the decimal separator.

12 as 12
1 as 1
but
1.2 as 1.200
1.25 as 1.250
1.5 as 1.500

like the above numbers...

 

[prabha_friend]

I don't want to change the values (by using int( ) ). But just want to show using the format codes. Possible?

 

[plog]

You need a Format call:

MS Access: Format Function (with Numbers)

This MSAccess tutorial explains how to use the Access Format function (as it applies to numeric values) with syntax and examples. The Microsoft Access Format function takes a numeric expression and returns it as a formatted string.

www.techonthenet.com

Inside an IIF statement:

MS Access: iif Function

This MSAccess tutorial explains how to use the Access iif function with syntax and examples. The Microsoft Access iif function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

www.techonthenet.com

Where you test to see if the original number is equal to its Int() value:

MS Access: Int Function

This MSAccess tutorial explains how to use the Access Int function with syntax and examples. The Microsoft Access Int function returns the integer portion of a number.

www.techonthenet.com

 

[prabha_friend]

Sales_Qty: IIf([Sales_Item_Unit_Qty]=Int([Sales_Item_Unit_Qty]),[Sales_Item_Unit_Qty],Format([Sales_Item_Unit_Qty],"#.000"))

 

[prabha_friend]

You need a Format call:

MS Access: Format Function (with Numbers)

This MSAccess tutorial explains how to use the Access Format function (as it applies to numeric values) with syntax and examples. The Microsoft Access Format function takes a numeric expression and returns it as a formatted string.

www.techonthenet.com

Inside an IIF statement:

MS Access: iif Function

This MSAccess tutorial explains how to use the Access iif function with syntax and examples. The Microsoft Access iif function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

www.techonthenet.com

Where you test to see if the original number is equal to its Int() value:

MS Access: Int Function

This MSAccess tutorial explains how to use the Access Int function with syntax and examples. The Microsoft Access Int function returns the integer portion of a number.

www.techonthenet.com

Thanks Plog