=DCount Two Different Values In one Field

vdanelia

Registered User.
Local time
Today, 09:10
Joined
Jan 29, 2011
Messages
215
I'm Counting values in the table field like this:

=DCount("ID","DATA","Product = 'DESKTOP'") If in the database is 50 desktops it shows 50..
Now i want to Count Two or more different values (for example if i have 50 Desktops and 50 laptops, it must count as 100)
I write another code, but not works and shows errors:
=DCount("ID","DATA","PRODUCT = 'DESKTOP','NOTEBOOK'")

What i Did incorrectly?

Thank you in advanced
 
=DCount("ID","DATA","PRODUCT IN('DESKTOP','NOTEBOOK')")
 
Perfect!

Thank You Boblarson, Greatest Thanks!
 

Users who are viewing this thread

Back
Top Bottom