Null Query Results

[bcarter17]

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.

[xps35]

I don't know what exactly you tried, but this one works for me:

SELECT Count(Sales.TicketNumb) AS Loads, nz(Sum(Sales.NetTons),0) AS Tons
FROM Sales
WHERE Sales.SalesDate=Date() And Void = False;

[bcarter17]

Thank you Peter! We're wrapping up the day here, so i will give that a try in the morning. Thanks for the response!

[bcarter17]

Just set this up and it works on my end as well, thanks Peter! Appreciate the advice on this.

[ArviLaanemets]

Btw., Some value + Null = Null (Null isn't same as 0, it means that there is no value). This explains why you got nothing when summarizing! And Nz() in Peter's example replaces Null value with 0 - i.e. with a real number.