dlookup prob

[faberk]

Im not sure why this dlookup is not working. When i add the AND to my
conditions i return an error 13-type mismatch.

intFeb = DLookup("[FEB]", "[qryLabourDataInquiry]", "[ChildCCtr] = '" &
strCCtr & "'" And "[ChildId] = 97")

The variable strCCtr is a string and intFeb is decalred as a double. The
ChildId field in the query is an long integer. They work independently of
each othger, but return the 13 error msg when used together.

Thanks

 

[Ken Snell [MVP]]

You have too many " characters:

intFeb = DLookup("[FEB]", "[qryLabourDataInquiry]", "[ChildCCtr] = '" &
strCCtr & "' And [ChildId] = 97")

 

[faberk]

Thanks.

You have too many " characters:

intFeb = DLookup("[FEB]", "[qryLabourDataInquiry]", "[ChildCCtr] = '" &
strCCtr & "' And [ChildId] = 97")
--

Ken Snell
<MS ACCESS MVP>

Im not sure why this dlookup is not working. When i add the AND to my
conditions i return an error 13-type mismatch.

intFeb = DLookup("[FEB]", "[qryLabourDataInquiry]", "[ChildCCtr] = '" &
strCCtr & "'" And "[ChildId] = 97")

The variable strCCtr is a string and intFeb is decalred as a double. The
ChildId field in the query is an long integer. They work independently of
each othger, but return the 13 error msg when used together.

Thanks

 

[Albert D. Kallal]

try:

dim strWhere as string

strWhere = "[ChildCCtr] = '" & strCCtr & "' And [ChildId] = 97"

intFeb = DLookup("[FEB]", "[qryLabourDataInquiry]", strWhere)

It looks like you got a extra " here:

------->"[ChildId] = 97")