How to display a count based on criteria.

[TimE]

How do I display a count based on a criteria? For example, I have
=Count([Type]) which of course will display a total of the records based on field [Type]. But now I want to count all the records by field [Type] if [Size]="x". Can you point me in the right direction?


As always, thank you for any assistance.

 

[Matt Greatorex]

Use DCount.

There are plenty of notes around on it's use, but the basic format is

Variable = DCount("item", "tablename", "criteria")

Hope that helps.