I have:
1) Table1 containing fields: ID, Name, Wage, WorkingHours, Date,
2) Form1 containing: txtDate, txtCO
I must create a Function that Sum the Wage from last 5 days.
Exp1 = DSUM([Wage],[Table1],Where Date <[Forms]![Form1]![txtDate]-5)
But I must do it in SQL (VBA).
I can't undesternd...