sum a control

[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.

 

[Dennis Snelgrove]

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...

 

[SAC]

Thanks!