Macro Conditions

paulcrigh

New member
Local time
Yesterday, 22:12
Joined
Jan 26, 2010
Messages
8
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
 
DCount("ItemGroupCode","Customers",">10")

should be

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

David
 

Users who are viewing this thread

Back
Top Bottom