OK, so thanks to Tom I got the query sorted out and I am getting the info I want. Since the customer is not too picky I do not need to lay it out with the day going accross. However, what he does want is this.
Lets say that there are only 4 days that we got a lead so the query will output the four days and the total number of leads on those days. When I output the query, of course it shows the four rows. What he wans is, if there is a day that had no leads, he wants me to put a zero in the total field. Can someone offer some assistance as to how I do this? I am sure it is super simple. Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
