just got to go around in the query to make a pivot table like report
this is my sql view of my query
SELECT Sales_Item.Chinese_Name, "From " & [Forms]![Item_Compare_Report]![1st_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![1st_Period_End_Day] AS text1...