DCount()

  • Thread starter Thread starter Mikk
  • Start date Start date
M

Mikk

I am having some trouble trying to get this dcount()
function working properly. The following is what I have
put into the unbound text box:

=DCount("[DateMI]","[qryResidents]"," [DateEntry] is
between #1/1/03# and #3/3/03#")

[DateMI] is a field in the query [qryResidents] whree
[DateEntry] is field with dates ranging from 1/1/03 to
11/1/03. Any thoughts as to why I keep getting an error?
 
Try removing the word "is."

=DCount("[DateMI]","[qryResidents]","[DateEntry] between
#1/1/03# and #3/3/03#")

David
 
Back
Top