sum a control

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I've done this several times but am having a problem now...don't understand
why.

I have a control whose control source = qty * priceea.

I've added another control whose data source = sum(qty*priceea) and I get
#Error.

I've looked at other forms I've made and it works on them.

What is going on?

Thanks.
 
About the only thing I can think of would be to suggest putting square
brackets around each of the fields; ie. "=Sum([qty]*[priceea])"

Also, check to make sure that those fields are actually in the query
source. It happens on occasion, even to the best of us... :-)
 
Back
Top