I need a report that shows item numbers and quantities ordered over a period of time. Most of the data is on a single table. My challenge is that I'm not grouping on a single field. The order form contains 10 fields (Field1 - Field10). So, on one order, part number 1234  might be in Field1 and on a different order that same part might be in Field 8. If you look at the raw data, the same values can show up in any of the 10 fields.