DSum in report

[Dulux]

On a main form [Frm1] I have a combobox [CmbProduct] with three choices in the row source: "product a", "product b", "productc". Also one field [txtvolume].
I want the total sum volume of each product displaid in the report.
Ie. Product a "total"
Product b "total" etc.
On the report page in the header section are three textboxes one for each product, with the control source :
=DSum([txtvolume],[table1],[txtproduct]="product a")
when I run the report asking me to enter parameter values.
Any ideas?

 

[pbaldy]

Here's a handy reference on the proper syntax (note quotes):

http://www.mvps.org/access/general/gen0018.htm

 

[Dulux]

Thanks for your reply, tried various options, if I don't get a syntax error I get "enter parameters". Still working on it.

 

[pbaldy]

Post what you've got if you get stuck, along with the error. The parameter prompt would most likely result from a misspelled table/field name.