• sounds like you may need something like a pivot table query

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)