|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 10th, 2009, 03:23 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Temporary Variables
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: 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 
|
|
#2
December 10th, 2009, 09:30 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Temporary Variables
hi Ken,
On 10.12.2009 04:23, KenB wrote: 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: 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 TempVars are stored and retrieved as Variant. So I assume this is the cause of your problem here. Use a cast like this: IIf(tblField = CInt(TempVars!MyIndex),.....) mfG -- stefan --
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
