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 = '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