Hello everyone,
I have what should be a simple one. It is more cosmetic than anything else but some users have brought it up. On a form we use, I have a button that opens an "Update" form, to show the user how many total loads, and how many tons of material have shipped on the current day.
But, until we get the first load of the day, the query seems to be able to count up the number of loads (none) and report a 0 back, but for the sum of tons, it shows blank.
I have tried several different possibilties of use NZ, DCount, IIF, etc. with no luck.
All help appreciated.