Dcount field

[ElTipo]

Hi People

I need to count different products in a report textbox or put the expression in a query for example:

=Dcount([productsID]).

¿How i can't this?

[PianoMan64]

Hi People

I need to count different products in a report textbox or put the expression in a query for example:

=Dcount([productsID]).

¿How i can't this?

If you look in Help file in Access there is an example of how to use DCount() and all it's parameters.

[ElTipo]

Thanks! Sorry I can't explain clearly.

Here is the real example issue:

I have a table named [products]. I need to count only one in list.

[ID] [ProdName] [price]
1 paper $1.00
1 paper $1.00
2 pencil $2.00

=Dcount([tblproducts],[ID], [ProdNamed]="Papaer") - This is correct? I need to count in the text box report only the paper product. But no work the Dcount to diference count.

¿How?

Thanks for your time. Excuses for my english.