raziel3
Registered User.
- Local time
- Yesterday, 23:27
- Joined
- Oct 5, 2017
- Messages
- 275
Hello,
I have query with the following fields from the Data Table
DaysWork: CloseDate
Lane: Source
ClosingCash: Cash
PrevDate: Format(DateAdd('d',-1,[CloseDate]),"dd/mm/yyyy")
Opening: Dlookup("ClosingCash","Data","[Source]= '" & [Lane] & "'" AND [CloseDate] =#" & [PrevDate] & "#")
Lane/Source is a text field. The problem I am having is the Dlookup returns the previous day's Cash but in some of the fields. The fields with text like CashDrawer'1 (I did not label this) returns #Error and other fields remains blank. What am I doing wrong?
I have query with the following fields from the Data Table
DaysWork: CloseDate
Lane: Source
ClosingCash: Cash
PrevDate: Format(DateAdd('d',-1,[CloseDate]),"dd/mm/yyyy")
Opening: Dlookup("ClosingCash","Data","[Source]= '" & [Lane] & "'" AND [CloseDate] =#" & [PrevDate] & "#")
Lane/Source is a text field. The problem I am having is the Dlookup returns the previous day's Cash but in some of the fields. The fields with text like CashDrawer'1 (I did not label this) returns #Error and other fields remains blank. What am I doing wrong?