Macro Conditions

[paulcrigh]

Hi There,

I have been reading the Access help manuals on how to build a condition within a macro but cannot seem to get it working.

Can anyone help me with the syntax please:

All I am trying to do is set a condition which will do a count of the values populated within the "ItemGroupCode" column of the query called "Customers" where the result is greater than 10, this is how I tried it with no luck:

DCount("ItemGroupCode","Customers",">10")

any help is appreciated

paulcrigh

 

[DCrake]

DCount("ItemGroupCode","Customers",">10")

should be

DCount("*","Customers","ItemGroupCode>10")

David