Export Crosstab query to excel

[barkarlo]

I made a crosstab query "Query1", which shows me that the driver of the vehicle is on the tour, dates per day, and relations between cities. I need that a query export to excel file and display it as a Gantt chart.
Is it possible?.
For example: if one carrier to the vehicle has more tour a month I would like to show all of his tours in the line chart.
In the attachment is database.

 

[CJ_London]

try using docmd.transferspreadsheet to populate a spreadsheet then have your gant chart in Excel refer to the data.

There are a number of threads on this forum which explain further

 

[barkarlo]

Thank you for the very useful advice.

 

[barkarlo]

How to apply the formula in Access from an Excel spreadsheet, which is attached to the ship,
IF (COUNTIF (A: A; O3)> 1; K3/SUMIF (O: O, O3, K: K), 1).
The formula calculates the coefficient of the number of passengers per transfer.

 

[barkarlo]

Crosstab to excel with code

When a crosstab query "Itinereri_Crosstab" exporting to excel from forms "CreateCalender"
I can see everything except the daily distances from field values. What changed in the code that it works.
Attached to send database.