crosstab query

[barkarlo]

In The Access database writes data about bus tours.Records are: start date, end date, name tours, number of passengerer, place of arrival and departure, etc.
For example: name "Fabulosa", pax 45, arrival: Ljubljana 12.01.2013., departure: Dubrovnik 21.01.2013..
How to make a crosstab query which would include columns StartDate and ENDDATE were presented column


all days of the year.
for example:
Row heading: STARTDATE, ENDDATE, name tours
Column heading date: 1.1.2013., 2.1.2013., 3.1.2013., .............. 31.12.2013 ..
Value: the highlighted range between StartDate and ENDDATE.
Thanks for your reply,

[June7]

One way is to do two crosstab queries - one for StartDate and one for EndDate - then join the crosstabs on the common ID key.

Review http://allenbrowne.com/ser-67.html

Stabilizing a crosstab to run perpetually in a report is tricky, especially when pivoting on dynamic date criteria. The above link might help with that, also
http://www.access.hookom.net/Dynamic...rosstabRpt.htm
http://support.microsoft.com/kb/328320

[barkarlo]

Copy of Ture2013 with itinerary.mdb

One way is to do two crosstab queries - one for StartDate and one for EndDate - then join the crosstabs on the common ID key.

Review http://allenbrowne.com/ser-67.html

Stabilizing a crosstab to run perpetually in a report is tricky, especially when pivoting on dynamic date criteria. The above link might help with that, also
http://www.access.hookom.net/Dynamic...rosstabRpt.htm
http://support.microsoft.com/kb/328320

The database, which is attached to the ship, there are a few tables, queries and forms.
One of the tables is the "Itinerary" in which the data is stored names tour, days on the tour (like 1Day, 2day, 3Day, ...) and relations between the two cities.
I would like to see in a query where the bus route by days between the start date and end date tours.
Something similar query "query1" only instead 1Day, 2day, 3Day, ..... should see the days between two dates.
Can it be done and how?.
If you don't open, open with shift-enter button.
Thanks

[June7]

The Intinerarytour table is not a normalized structure.

What you want will probably require VBA code.

You are trying to build a calendar?

Calendar database is not easy but has been done. Search forum or google. Review https://www.accessforums.net/forms/c...ess-24472.html

[barkarlo]

Copy of ture2013 - Copy (2).mdbIn the database, I am sending you, I have a crosstab query "bustourname_crosstab" which shows me the dates between the two dates, and the value is displayed as "X" under each date that corresponds to the range of the start date and end date.
Use the form "CreateCalender" create excel file in which the range of cells below the daily date highlighted in red, and the corresponding duration tours.
This is good if you want to see a graphical representation for bus tours, but
I want to see the query that would graphically show per tour bus schedule
in the line.
For example: The bus, which was scheduled to tour "Semana Santa1" from 23.3.2013 to 31.3.2013 and again on tour "JTBTC7P9" from 3.4.2013. to 10.4.2013. that it is displayed in a line.
Now they can do it only to make two lines.

[barkarlo]

The Intinerarytour table is not a normalized structure.

What you want will probably require VBA code.

You are trying to build a calendar?

Calendar database is not easy but has been done. Search forum or google. Review https://www.accessforums.net/forms/c...ess-24472.html