- when concatenating, the ampersand (&) is never within quotes
- if strTable and strField are variables, I'd say also no quotes, otherwise you're passing literals; i.e. the table is named "strTable"
- not sure what to say about ID vs [ID]. If ID is a variable, same could apply. However in the case of one is variable and the other is field name, the variable name is a poor choice given that it would be the same name as a field. Might also expect ID to always be < ID+1 if they're the same thing. Anything you add to [ID] will always make it greater.
P.S. as for trying to use IsNull, if it helps, this works
dcount("Dte","tblMyTable","Not Isnull(dte) and [ID] < 4")
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.