Cross query in Access database?

Question

SQL

There are 3 tables
1. People (Personal number, full name)
2. Dates (Order No., Date)
3. Schedule (Date, outfit 1, outfit 2, outfit 3, outfit 4)
In outfit 1,2,3,4, people are selected by number through setting. On the Date Date of the Order by the number of the order.
We need a cross query that will display a column with surnames, there will be dates in the title, and in the values ​​Dress or the letter D. I tried a bunch of options. Little experience with sql and with cross queries. Please help me create a request

Answer 1

MICROSOFT+ACCESS+PIVOT