Dcount function

[oggsta]

I would like to count all those feilds
on form/table main that equals South East AND
Form/table Sheet1 that equals '4. PLANNING APPLICATION SUBMITTED,

For some reason the formula below is unsuccusful, i think it has something to do with this line, Forms!Sheet1![Sitestatus]. It works fine with the one table or form but when you introduce a second it does not seem to work.

=DCount("[MainID]","Main", "[Region] = 'South East' AND Forms!Sheet1![Sitestatus] = '4. PLANNING APPLICATION SUBMITTED'&quot

Any help appreciated;

 

[pervinpj]

If I'm correct as to what you're trying to do, what you need to do is create a query containing all of the fields on main that equal "South East", and all records on Sheet1 that equal "4. Planning Application". Use the DCount function on that query.