Itinerary Report

[priden]

Greetings,

I am trying to construct an itinerary to be organized by day. It also must include possible flights, rental cars, taxis/limos, events and hotels.

So, what I want would look something like:

July 16, 2012

Flight
-all relevant flight info including airline, ticket number, arrival and departure times
Hotel
-address, name, etc
Rental Car
-company, pick up time, etc
Taxi
-pick up location, etc
Events
-time, location, address, confirmation number

July 17, 2012
-Flights on july 17
-hotels on July 17
-events on july 17,

July 18, etc..

The problem is some days require hotel changes, some require rental cars or taxis while some days just require a basic timeline of events.

Is it possible to create a report this flexible?

Currently my database looks something like:

tblTraveler
TravelerID
FName
LName

tblTrip
TripID
TripStartDate
TripEndDate
TravelerID

tblFlights
TripFlightID
TripID
Flightconfnum
FlightDate
FlightDepartTime
FlightArriveTime
Airline
FlightNumber

tblEvents
eventID
TripID
TimeStart
TimeEnd
EventDate
EventName
EventAddress
EventCity
EventZipCode
EventPhone

tblHotels
triphotelID
TripID
HotelConfNum
HotelName
HotelCity
HotelStartDate
HotelEndDate
HotelPhone
HotelAddress
HotelFax
HotelZipcode

tblLimo
LimoID
TripID
DriverFname
DriverLname
DriverCell
PUTime
PULocation
Company

CarRental
TripCarID
TripID
CarCompany
CarConfNum
CarPUlocation
CarStartDate
CarEndDate
CarType
CarCompanyPHone

So far I've created reports based off each table--CarRental, Hotels, Flights, limo, events. What I want to do is bring all of those reports together on 1 report organized by day. Is that even possible?



Thanks in advance for the help!

[ssanfu]

Maybe create a report with sub-reports (using the reports you have already created)????