crosstab - Using Text in a Cross tab query or other options

Question

I have created a small database for our golf club and I am trying to reproduce a "excel" like spreadsheet instead of duplicating the data in 2 formats. I have a query that has

TeeTime (time Format) Fullname (Text) Course (Text) EventDate (Date)

Example Date: 7.00am John Smith Pelican Waters 30/6/2020 7.00am Roger Moore Pelican Waters 30/6/2020 7.00am Peter Day Pelican Waters 30/6/2020 7.00am Alan Scott Pelican Waters 30/6/2020 7.06am Dustbin Johnson Pelican Waters 30/6/2020 7.06am Long Daly Pelican Waters 30/6/2020 7.06am Lion Woods Pelican Waters 30/6/2020 7.06am Greg Normal Pelican Waters 30/6/2020

this is all coming from a temp_table I created to get the data all together as the original query gets all the information from a number of queries and tables

I am trying to get a report to have the look of

7.00am John Smith Roger Moore Peter Day Alan Scott
7.06am Dustbin Johnson Long Daly Lion Woods Greg Normal

Any suggestions Thanks

Answer 1

等待大神答复