Crosstab query help for monthly rep percentages

[Ace71425]

Hello i know this should be easy but im having a difficult time with it...So I have a query that displays a rep's name, a date, and a percentage for the day...See below

Something like

Billy 10/20/2015 10%
Billy 10/21/2015 25%
Billy 10/22/2015 55%
John 10/16/2015 72%
John 10/18/2015 75%
John 10/30/2015 90%
Mary 10/22/2015 60%

Now what I would like is for a crosstab query to filter it like this...

Rep 10/1/2015 10/2/2015 10/3/2015 10/4/2015 10/5/2015 10/6/2015 10/7/2015 10/8/2015 10/9/2015 10/10/2015 10/11/2015 etc etc
Billy 20% 30%
John 55%
Mary 75% 90% 88%


I think you get the idea....So how do I get this accomplished I don't really understand the row and column and value settings for the fields and just get errors left and right..Thanks!

 

[Ace71425]

Of course keep in mind the percentages will line up with what date and rep they were on in my post it just formatted them all back in a row....

 

[Fazza]

TRANSFORM SUM(percentage)
SELECT name
FROM table
GROUP BY name
PIVOT dates

 

[Micron]

Of course keep in mind the percentages will line up with what date and rep they were on in my post it just formatted them all back in a row....

What helps keep data lined up in this forum is to create in Excel, then copy/paste here. Voila! Instant html table.