Replacing Dlookup with a select query in Ms Access VBA
Help me to replace the Dlookup below in Ms access VBA Code with a select query , I understand the performance will be very good:
Regards
Chris
DLookup("Quantity", "QryJson", "InvoiceID =" & Me.InvoiceID & " AND ItemesID =" & CStr(i))
Regards
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EXPERT CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.