How to hide decimals in the form field

[azhar2006]

Hello Guys
How to hide decimals in the form field
For instance


0.935
935 but when it becomes a mathematical operations it will be 0.935
But it appears in the form 935

[orange]

Multiply by 1000

[ItsMe]

If you know there will always be three positions past the decimal you can multiply the fraction part of the value by 1000 to get the result you want.

There would have to be a specific set of rules in place to do this. You may need to write some code to determine if there is a whole value in the figure before you multiplied by 1000 and check other things also. You would need to be sure there are not more than three decimal places, for example.

I would use an unbound textbox to display the calculated value. However, it looks as though you have a continuous form and an unbound textbox will not work in continuous view.

You may have to create another column in your table and store the calculated value. Perhaps a calculated field in your table will work. You could name your new field something to indicate it is for viewing purposes and not to be used for other reasons.

[azhar2006]

Thank you
No No. 1000
The last number is 999
And that this field is undergoing a math equation
And do not aspire to write user 0.925
I just want to write a number
In the query is not considered 925 but considers 0.925

[ItsMe]

Instead of a calculated field in a table you could create an alias in your query and do the math there in the query. This will work if the value is always three decimal places and no whole numbers.

[azhar2006]

In the future,
How can I do the filter to these categories
It is three to four digits only
999
900
935
925

[ItsMe]

I don't understand what you mean when you say, "filter". You can use a combobox to select one of the values and then associate a subform to the selection.

If you have three or four decimal places a general rule of multiplying by 1000 will not work.

[azhar2006]

Thank you
Attach your database
View the form Table1 Subform

[June7]

Why is the data in the Purity field sometimes 0.925 and sometimes 925? Should be consistent with data entry and then will not have an issue. Could use ValidationRule to force input to be >= 0 or <=0, whichever you prefer.

Otherwise, consider:

IIf(InStr([purity], "."), [purity] * 1000, [purity])

Should give calculated fields more meaningful names than Expr1, Expr2, etc.

[azhar2006]

Thank you very much
Yes, but I gave her the names of the form
Open the form in Design
It describes the column headers

[June7]

Regardless of captions in labels, field names are still Expr1, Expr2. I always change these default names to something informative.

[azhar2006]

OK
1. (Expr1) Is the price per gram * Quantity
Where the quantity is (grams) 1000 grams = 1 kg
2. (Expr2) Is the price of one gram - wage work
That's where the wages of labor per gram and should be enacted, not dollars
For example, for every one gram wage work (0.10) cents

[June7]

Is your original question resolved with the expression I suggested?

Do what you want about the field naming, was just a suggestion.

[azhar2006]

The problem is
If (purity)
925 and 0.925 will not be there is an error in the total amount for the price of Gram
For example, the price is 610 cents Gram and wage labor is .10 cents
Output is 610.10 be a mistake
Must be 620 cents
What is the solution?
Thank you for your cooperation Guys

[azhar2006]

Try to delete the comma from 0.925
Then type 925 and note
Field (Price per gram with wages)
The field (Price per gram without wages)