Recent content by Atomicguy

Thank you very much. It is working now.

Ok. Got It. now small issue... When I apply this formula I get integers only and any decimal values are not showing. All text fields Format are set to General Numbers. If I do this test: TextBox1 = 1 and LabourTime = 1 so therefore (1 + 1*35+55)*1.5 = 136.5 But the TextBox6 = 136. No decimal...

Yes. Sorry about the discrepancy. I am now using the value 35 and 55 and 1.5. I have noticed you used value 40 in the formula? If Nz(Me.Labour, 0) * 40 <------------ Labour time * Minimum labour charge (Labour time * 35) I am I right to think that what it should be? When I apply this...

I am trying to calculate a total cost by taking into factor some static values, for example: £35 as minimum labour charge £55 P&P and other cost 1.5 ratio TextBox1 to TextBox 4 are just the costs of parts (if parts are used at all then I want to be able to fill up the text boxes) Labour...

It is displaying something on Textbox6 but not the result I am expecting. Is there something wrong with my expressions? If all input text fields contain value 0 at least the output value should give me (40 + 60)*1.5 = 150 but I am getting 90? I think the calculation is only taking 60 * 1.5...

Thank you for your help. How would I do this on a command button? I want to click the command button and the calculated result should display on TextBox6.

Hi. Wondering if someone can help me with this problem I am having. In a form I have few text box where I want to take the value someone insert into these text box and do a calculation. I have Five text boxes and one command button. When command button clicked the result should be shown on...