Dcount problem

[indesisiv]

I have a bit of a problem combining a dcount ...

I have
=DCount("[Ethnic group]","[qryDOH]","[Gender] = 'Male' and [Ethnic group] = 'Black'")

but i want the selection bit to include something like ...

"([Gender] = 'Male') AND ([Ethnic group] = 'Black' OR [Ethnic group] = 'Asian')"

Hope that this is explained well enough

Any help greatly recieved ...

Steve

 

[Stew]

Give the following a try:

"[Gender] = 'Male' and [Ethnic group] = 'Black' Or [Gender] = 'Male' and [Ethnic group] = 'Asian'")

Paul