Error in Report when value is not Found

[SealM]

This is probably a simple solution, but I haven't found a good example I can apply when searching here. I'm attaching my database, and I've stripped out everything that doesn't pertain to this particular report. The report in question is the SUMMARIZED report. I've left the detailed one in there for perspective.

Here's the problem. In the RAW table, there is a field called "Business_or_Personal" (I know, silly name). This field is a user-input field from the e-mail collection process. It will have either "Business", "Personal", or "other" in it. This is all good, and works fine. The SUMMARIZED report, however, only will display and calculate if there is one of each of these three items in the "business_or_personal" column. In other words, when I go in and remove the "other" from the table in this column, the report no longer runs.

I don't know if this is a problem with the query associated with the report, or the report itself. This was my first pivot query, and I did some new stuff to sum(total) in the report. I can't tell where specifically the error would be coming from though.

Any help would be great! Thanks in advance!!
test.zip

[June7]

This is the problem with reports based on dynamic crosstab queries. The report has textboxes bound to fields Business, Personal, Other, <> but if the query does not generate a field for each of these bound textboxes the report errors.

Google: Access dynamic crosstab query report

Here is one: http://allenbrowne.com/ser-67.html#ColHead

Specifying these Column Heads seems to work for your query: "Business","Personal","Other",Null

[SealM]

That worked brilliantly! Thanks for the reference material as well. In the website it listed a bad condition being that ONLY column headings that you list would show up, but adding the NULL at the end of it worked as a catch-all in my case, as I only wanted a column of the count of items NOT in the other columns as well. Thanks so much!!