Return 0 instead of null

[salisbut]

I thought this was a simple problem, but I cannot make progress on it no matter how many IsNull or Nz functions I try. In the database attached, in qryReturnArrowRock and qrySaleArrowRock I want the MW and $ to return 0 if there are no records. This is the problem is that there are no null values to convert to 0! I looked at this article for awhile, http://www.databasejournal.com/featu...-not-there.htm but couldn't quite get it to work on mine. A good month to test on the Arrowrock queries is July 2010 and you should not return any values. Queries can be generated by using frmWholesale. Any help would be appreciated...Thanks!

[ajetrumpet]

if you want someone to help, try posting it in mdb format