mfaisal.ce
Member
- Local time
- Today, 09:05
- Joined
- Dec 21, 2020
- Messages
- 76
Hello,
I have multiple records with same date in a table and i want to find the last entered record with that specific date... how i can use that with Dlookup function...
DLookup("Balance", "Sales", "CID=" & CID.Value & " and datevalue(Sdate) = #" & DMax("Sdate", "Sales", "CID = " & CID.Value) & "#")
where;
Balance - Field Name
CID- Filed Name
SDate- Field Name
Sales - table Name
kindly guide..
I have multiple records with same date in a table and i want to find the last entered record with that specific date... how i can use that with Dlookup function...
DLookup("Balance", "Sales", "CID=" & CID.Value & " and datevalue(Sdate) = #" & DMax("Sdate", "Sales", "CID = " & CID.Value) & "#")
where;
Balance - Field Name
CID- Filed Name
SDate- Field Name
Sales - table Name
kindly guide..