Dcount Problems??

[Andrew Pla]

Hi there from Sunny Hull.

Im having trouble using a DCount to count the number of records in the table that are LIVE or CLOSED and by each Region (eg North, South, East, West)
If i use a simple =count(*) to count the total no. of records per region, it is working fine. But when i turn this into =DCount("*","Suppliers","[type]='Live'") the count is now counting all Live Records rather than just by Region. How can it work?

Please could someone help me save my ass!!

Cheers!

 

[phn]

small world, i live in hull too! where abouts are you?