[textbox one]=[qty]*1000
[textbox two]=[qty]*20
Both of the form textboxes are in brackets they don't need to be in brackets if there is no spaces in their name. Also textboxes may have different names then the table field names they represent so check in their properties.
The calculated controls are in textboxes in a form. So basically, all I need to know is how to sum the values that come out of those two calculated controls. I tried doing the sum function but it only shows an #error thing.
Shall we say textbox one is qty*1000
textbox two is qty*20
I want to total the amounts that come out when I input the quantities. So I created another textbox that sums them using a sum function and obviously it didn't work.
I am not an IT person so I basically have no idea what I'm doing. :'(