Dcount

[AndyShuter]

Have got the following line in my CONTROL SOURCE which works great

=DCount("[FinanceCompany]","qryReport","[FinanceCompany] = 'Lloyds'")

What I would like to do is add another condition to the search parameters, but am unsure where the & (or And) bit goes.

For example, I would like to sprecify that not only would I like to count all records in the query that equal "Lloyds", but those that are new cars as well with Lloyds

=DCount("[NewOrUsed]","qryReport","[NewOrUsed] = 'New'")

Any ideas how I would combine this???

 

[wizcow2]

Give this a try.

=DCount("[FinanceCompany]","qryReport","[FinanceCompany] = 'Lloyds'" AND "[NewOrUsed] = 'New'")


Tom

 

[wizcow2]

Sorry Andy.

Pat is correct, of course.

Tom

 

[AndyShuter]

Thanks !!

Thanks!!