Unanswered: Putting 0's in Null Fields in a Crosstab Query
I have a table and related crosstab query based on the following info (simplified for ease of reading here):
UPC number of the sold bar
Basically, I've created a crosstab with different "candy bars" in the rows and Date sold as the columns, using UPC as the "data". In a 100 day period, at least 1 candy bar is sold every day, although not every brand is. My crosstab shows how many of each candy bar was sold in that day. HOWEVER, I want the query to fill out the blank (null) fields with a 0 (if that particular candy bar brand wasn't sold on that day - There is no "0" entry in the table, rather nothing was entered for that day) . For example, a Crunch bar may have been sold yesterday, but a Hershey bar was not. Any insight into a solution would be much appreciated!