DCount #NAME? error

[gmmccarthy]

This is my string to calculate the next increment # based on request date and users initials.

However, I get the #NAME? error when I run the form?


=DCount("[INCR]","tblPURD","[reqdate]=" &
Format(me.txtreqdate,"\#mm\/dd\/yyyy\#") & " AND [initials] = '" &
me.txtinitials & "'")+1

Any help will be appreciated.

Thanks.

 

[RuralGuy]

Have you tried:
=DCount("[INCR]","tblPURD","[reqdate]= #" & me.txtreqdate & "# AND [initials] = '" & me.txtinitials & "'")+1

 

[gmmccarthy]

Thanks for the response.

I get the same error either way.

Gary

 

[RuralGuy]

I would check the spelling of each of the names next.