I created a cross tab query that is based upon another query.
Crosstab Query
TRANSFORM First(Query_Reports_Range.[Vent]) AS FirstOfVent
SELECT Query_Reports_Range.[MedID]
FROM Query_Reports_Range
GROUP BY Query_Reports_Range.[MedID]
PIVOT Format([Daily_Rounds_Date],"Short Date");It works...