chart tours

[barkarlo]

I made database with following data:

tour   startdate  city         enddate         city 
was    04.04.09    Venezia      14.04.09       Berlin          
asahi  15.04.09    Berlin          23.04.09      Madrid          
neds   11.04.09    Wien          18.04.09       Trieste         
mbok   19.04.09   Trieste        24.04.09       Paris
osaka   25.04.09   Paris          02.05.09      Ljubljana

This records represent bus tour across europe and I must well planned exploit a bus.
I want make a chart where will be show all tour which ending in the same city where another tour beginning (one or two days later).

[barkarlo]

Maybe someone has good idea how well planned bus tour.

[JustJim]

I made database with following data:

tour   startdate  city         enddate         city 
was    04.04.09    Venezia      14.04.09       Berlin          
asahi  15.04.09    Berlin          23.04.09      Madrid          
neds   11.04.09    Wien          18.04.09       Trieste         
mbok   19.04.09   Trieste        24.04.09       Paris
osaka   25.04.09   Paris          02.05.09      Ljubljana

This records represent bus tour across europe and I must well planned exploit a bus.
I want make a chart where will be show all tour which ending in the same city where another tour beginning (one or two days later).

Hi,
I don't know what sort of "chart" you want to make, but the following SQL will select the tours that fit your needs.

[CODE=sql]SELECT TourData_1.Name AS PreviousTour, TourData.Name, TourData.StartD ate, TourData.CitySt art, TourData.EndDat e, TourData.CityEn d
FROM TourData INNER JOIN TourData AS TourData_1 ON TourData.CitySt art = TourData_1.City End
WHERE TourData.StartD ate>TourData_1. EndDate And TourData.StartD ate<DateAdd("d" ,3,TourData_1.E ndDate)[/CODE]

[barkarlo]

That's it.
Thank you.

[JustJim]

That's it.
Thank you.

My pleasure, glad to be of assistance.

Jim