G
Guest
I am using the dlookup function on a form to retrieve a value from a table,
from the last time this form was completed for a particular customer. This is
so that I can perform a calculation based on the old value and the new one
entered on the form.
However because there is more than one instance dlookup returns the first
value rather than the last.
I thought dlast may work but I'm being unsuccessful!
Any help?
Ian
from the last time this form was completed for a particular customer. This is
so that I can perform a calculation based on the old value and the new one
entered on the form.
However because there is more than one instance dlookup returns the first
value rather than the last.
I thought dlast may work but I'm being unsuccessful!
Any help?
Ian