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