ContributionsMost RecentMost LikesSolutionsHow2create ONE summary report pulling from 12 different fields, with 5 different categories in each field, that are all on the same record? How do I create ONE summary report pulling from about 12 different fields, with 5 different categories in each field, that are all on the same record? I have a table named [Customer References] and there are 12 fields on the record that I need to summarize in one report that represent (type of reference asset). There is one field for case study, video, press release, ect. Each field has an asset pipeline status; confirmed, complete, published, ect. What I need to do is create a summary report that brings in all 12 fields from the Customer Reference record with count of the categories under each field. The ideal report would have the (type of reference asset) as the column header and the rows would be the categories. And there would be a totals row at the bottom with counts of the categories in each Colum. But I can only have 6 crosstabs with this report and I need all 12 assets.Is there another way to build a summary table that has more than 6 cross tabs? Re: Sneak Peek: Type-Ahead Search PickertestRe: How to relate many records to many other records in the same table?Hi Mark -- I am having an issue with something similar... I need to create a summary report. All my data is on one table. But I have about 12 different fields with 5 different status categories, and I have to create one report showing a summary for each field reflecting the status. Because there are 12 different fields with 5 different status, I am having trouble bringing them all together in a report. Please help:)