Multipling Values of two textboxs UPrice * Quantity

[Altaful Haq]

i have a situtation where i have to multiply two values of text boxes where the UPrice value is 344 and its Quantity is 0.5 and put the result in the total

[June7]

Do calculations in query or in textbox. This calculation should be done when needed. The result should not be saved to table.

[Altaful Haq]

But i want to save the result in table some time the customer want to buy half of the material from the factory. There are multiple product they buy half from the two of the product and used the for there need.

[June7]

Saving calculated data is often a bad idea. But if you must, it requires code in some event to accomplish. Perhaps in the form BeforeUpdate event, VBA example:

Me!fieldname = Me.textboxname

[Altaful Haq]

When i put a value of (.5) or (0.5) it automatically converted into 0. what the reason behind it.

[June7]

Are you saving that to an Integer type field?

[Altaful Haq]

no the type is decimal

[June7]

Is this display of 0 in textbox on form or in table? Sounds like formatting is set for no decimals.

[Altaful Haq]

Thanks i figure out the way of doing so. Thanks for Help