Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Format of temporary variables
0 views
Skip to first unread message
KenB
Nov 9, 2009, 3:02:02 PM11/9/09
to
I have a pointer stored in TempVars!MyIndex
Within DLookup( or DSum( references to TempVars!MyIndex work fine
but
IIf(tblField = TempVars!MyIndex, does not work.
As a work-around I tried this:
Within DLookup( or DSum( references to TempVars!MyIndex work fine
but
IIf(tblField = TempVars!MyIndex, does not work.
As a work-around I tried this:
Dim NewIndex as Integer
NewIndex = TempVars!MyIndex
IIf(tblField = NewIndex, and found it works well.
So just what is the difference between temporary variables and numeric table
fields? ---- Ken
0 new messages