With the "Qty On Hand" totals, where no entries exist, the COUNT shows "0 items". However, the SUM only shows "units" (not "0 units", as I was expecting). This still happens even when I have set default values to 0!. This may be normal for this part of the course, and I will find an answer later on?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.