Syntax Help

  • Thread starter Thread starter Murray
  • Start date Start date
M

Murray

Hi All
I have a Form that gets it data via a query. The form has a couple of Text
boxes that use the Dcount to count the number of records.
=DCount("[winLose]","QryStandard","[winlose]='win'")
The form also has a combo box to show the employees, is it possible to use
the vaule from the combo box to further filter Dcount so that only the wins
form the person are shown?
=DCount("[winLose]","QryStandard","[winlose]='win' &
[employee]=comboxbox.value")
If yes what is the syntax for the above
Thanks in advance
 
"([winlose]='win') and ([employee]= '" & comboxbox.value & "')")

Note the ' " and the " '. You don't want that if the employee is an employee
number.

sometimes it is also possible to use

"([winlose]='win') and ([employee]= [comboxbox]) ")

but that is a little more complex.

(david)
 
Back
Top