Hey, I have set up my Dfirst function, and I am getting an #Error, I have looked at the reasonings for this and my thinking still doesnt work.
Here is my SQL. the formula is NetCash...
Code:
SELECT
T1.AccountID,
T1.ClientID,
T1.ProductID,
T1.MonthlyDate,
T1.Cash,
(DFirst("[T1].[Cash]","qryAccountSetup","[T1].[ClientID]=" & [T1].[ClientID] & " And [T1].[MonthlyDate] <=#" & [T1].[MonthlyDate] & "#")) AS NetCash
FROM qryAccountSetup AS T1;
Now I have AccountID, which is Autonumber for the table. If i want to get the file 1 row ahead would define this in the DFirstFunction and get that value?