Menu

#2 Parameter not rendered in Access-specific query

open
nobody
None
5
2004-04-27
2004-04-27
Ted Husted
No

Using Access:

SELECT
DCount("[PERMITNO1]","plans931","Year([DATEREC])=
#value# ")

exposes an exception saying 1 parameter was expected
but zero were received.

If the year is hardcoded and no parameter is used, then
the same query works.

[TODO: Add TestCase]

Discussion


Log in to post a comment.

MongoDB Logo MongoDB