Dcount with matching a part of text criteria

[engr/masud]

I NEED HELP SINCE I TRAY TO USE THIS CODE with matching a part of text criteria.
BUT IT GIVE ME WRONG ANSWER

=DCount("[status]","all open woq","[department]= 'shom*'")
WERE THE SHOM* REFERE TO A PART OF TEXT
TAHNKS

 

[Vold]

Oops

Your Departments should be selectable with a number

Vold

 

[Vold]

Start again:
Dim strParameter as string
strParameter ="shom"

Try ...."[department] = " & strParameter &"*")


Good practices pay out in the end:

Your field should be called fldStatus

Your table/query should be called tabAllOpenWog/qryAllOpenWog
NoSpaces= Less Problems
or even better a constant, whose content can be changed when the table/query name changes

Your department should be a number like DepartmentId, you need a tabDepartment that with the corresponding hierarchy.

Rgds Vold