Multi Value Corsstab Query

[mindbender]

Hello gurus,

I have a table with the following data: Manager (Short Text), Rep (Short Text), Date (Date/Time), Dials (Number), TT (Short Text formatted to hh:mm:ss)

I am trying to get the query results to look like this. I am highly doubtful this can be done in a query but maybe a report? Just nto sure how to go about either.

Thanks in advance



4/11/2017 4/12/2017 MTD
Manager Rep Dials TT Dials TT Dials TT
Jones John Doe 6 2:12:33 8 1:15:34 14 3:28:07
Jones Paul Smith 8 1:34:55 12 2:45:55 20 4:20:50
TOTALS 14 3:47:28 20 4:01:29 34 7:48:57

[mindbender]

Formatting was junk... Attached Spreadsheet