By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,069 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,069 IT Pros & Developers. It's quick & easy.

chart tours

P: 59
I made database with following data:
Expand|Select|Wrap|Line Numbers
  1. tour   startdate  city         enddate         city 
  2. was    04.04.09    Venezia      14.04.09       Berlin          
  3. asahi  15.04.09    Berlin          23.04.09      Madrid          
  4. neds   11.04.09    Wien          18.04.09       Trieste         
  5. mbok   19.04.09   Trieste        24.04.09       Paris
  6. 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).
Apr 12 '09 #1
Share this Question
Share on Google+
4 Replies

P: 59
Maybe someone has good idea how well planned bus tour.
Apr 12 '09 #2

Expert 100+
P: 407
I don't know what sort of "chart" you want to make, but the following SQL will select the tours that fit your needs.

Expand|Select|Wrap|Line Numbers
  1. SELECT TourData_1.Name AS PreviousTour, TourData.Name, TourData.StartDate, TourData.CityStart, TourData.EndDate, TourData.CityEnd
  2. FROM TourData INNER JOIN TourData AS TourData_1 ON TourData.CityStart = TourData_1.CityEnd
  3. WHERE TourData.StartDate>TourData_1.EndDate And TourData.StartDate<DateAdd("d",3,TourData_1.EndDate)
Apr 13 '09 #3

P: 59
That's it.
Thank you.
Apr 13 '09 #4

Expert 100+
P: 407
My pleasure, glad to be of assistance.

Apr 14 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.