A DCount with multiple criteria

[jheiser]

I need to search a table to see how many times a status of open in found along with a specific computer name.

this is what i have

Count = DCount("[Status]", "EnovaBatchStatus", "[Status]= 'Open'" And "[CompuName] ='" & CompName & "'")

CompName is the name of the computer that is currently using the program.

It keeps saying type mismatch

Is there a way to use this function and search with both criteria

 

[LittleSmudge]

You shouldn't have the AND outside the quote strings


You need


Count = DCount("[Status]", "EnovaBatchStatus", "[Status]= 'Open' AND [CompuName] ='" & CompName & "'")



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[jheiser]

thanks