I'm building a report to print labels. I've connected it to an Access Database table. Each label however is not it's own record. The table is built in a way where all the data for one label is not in one record, but 15 records. I'm gong to describe this as the record being stored vertically, instead of the traditional way.
So how can I pull in 15 records as being one record? Each record that I'm trying to pull in would be the # in the PosID field. I've attached a screenshot. I've highlighted the records that should actually be one record or one label if you will.