I have a table with types of business, there are 7 (new, replacement, etc), becuase there can be more than one type of business, the field is a yes/no.

I have to generate a report, of all open business on one report ~ grouped together. Can this be done? For example all new business, grouped together, all replacement?

A field in your table for each type of business? Seven fields?

Yes, I'm starting to think a cross tab query?

I'm starting to think normalisation. ;)