I have a table with the following fields... Grossweight, Tareweight, Tons, ProductRate.
I would like to create a form for data input where I could either put in the tons and product rate and have the total show up in another field called Total Amt or put in the grossweight and tare weight and the product rate and have the total show up in another field called Total Amt. I have created a query and inserted the extra column in design form and entered '[tons]*[productrate] or [grossweight]-[tareweight]/2000*[productrate]'. This doesn't seem to work. Can someone point me in the right direction with the correct expression? Thanks, Harold
