Search results
-
S
DLookup / DMax Does Not Work Correctly
I can not get the DMax / DLookup function to work correctly. The IFF statement that I used works due to me having the startign value of 100. Can anyone please help me out? Beginning Bal: IIf([ID]=1,100,DLookUp("[Ending Balance]","GMPSortKPIQuery","[ID]=" & [ID]-1))... -
S
DLookup / DMax Does Not Work Correctly
I can not get this query to use the DLookup / DMax function correctly:mad:. I get an error every single time. The IFF part of the statement works, due to me having a starting value of 100. Can anyone help me out? Beginning Bal: IIf([ID]=1,100,DLookup("[Ending...