Recent content by MarcusAD79

theDBguy: The Nz( ) worked. Thanks! plog: Wow, I remember using that site back in 2000's for HTML4 😲 I'll start using it again. Thank you!

theDBguy: That worked!!!! (And sorry for missing where I was posting at first) I want to make sure I understand what I did wrong. There has to be a & between Criteria1 and Criteria2 and I had AND " before the Criteria2, it needs to be reversed, like this " AND . While it does work, is there a...

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...