Thank you, Not So "lameid"!
Thanks for reminding me of aggregate functions ignore nulls and the use of IIF function. I was able to do just that!
Sorry for a late reply! Deadline was looming and I had no time to inform you of your great tips.
Thank you, once again!!!
Please, help! This is my first post here, and I am fairly new to Access.
I have a report that I inherit from another developer:
Report Header => Water Flow
Page Header (columns) => "Month", "Min Flow", "Max Flow", "Avg Flow"
DATESTAMP Header => empty
Detail => empty
DATESTAMP Footer =>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.