Hi,
I have been trying for hours to get the following DLookup to work. I've read forum after forum and help pages to no avail.
Problem :
DLookUp("[DIFFRERENCE]","qrySubUsage","MeterID=" & [Sub1MeterID] And "CURRENT_READ_DATE=#" & [CURRENT_READ_DATE] & "#")
Source Query "qrySubUsage" has the...