dcount with 2 criteria

[Nobby2193]

Hi All
probably easy for you guys but frustrating for me

I have a form frmStatuslookup and its subform frmStatuslookup _sub. The recordsource for frmStatuslookup _sub is QryStatusLookup

on the subform I have a combo box called ClientOrDestination with ID and Databasestatus,

ID	databaseStatus
1	Active
2	Destination
3	Inactive
4	Void

and a field named Title which has either MR, Mrs, MIss or MS
In the formfooter of frmStatuslookup _sub I need to count up the occurences of MR from the title field where the contents of the combo box ClientOrDestination column 1 says "Active" I also have the ID field ( which would show 1 for active ) to try to make my dcount easier ??



I just cannot get a result to this
my best effort is =DCount("QryStatusLookup","clientordestination","[clientordestination]='Active' And [client]='Mr'") but comes up with error
Please help

[moke123]

your arguments are off.

DCount ( expression, domain, [criteria] )

the first argument should be the field you are counting or "*" usually works.
the second argument is the domain. in your case a query.
the third argument is the criteria. similar to a where clause.

[Nobby2193]

Hi
Thanks for your prompt reply

I did it with
=DCount("*","[QryStatusLookup]","title = 'Mr' And [id]=1")

Rob