Using a query result multiple times in a report

[Design by Sue]

This is for a cab company that needs to generate tickets for each leg of a
trip, ie. Point A to B, Point B to C, Point C to D and then Point D to A. I
would like to keep track of this in one table. The entire trip is assigned a
trip number. The address for each point is a separate record. There is an
autonumber field which keeps all records in the correct order. Putting it
another way: There may be many trips each day, but each trip can be
recognized by its trip number and the auto number indicates the order of the
stops, except the last which would be the return to the original location.

Now, I can do a simple query to get a trip with each of its stops, A, B, C,
D. Is there any way to use this query to create a report that shows:
Location one to Location two, Location two to Location three, Location three
to Location one. I need to use the same field twice on the report.

Hope I've expressed that so some one of you experts can understand and
answer. (and I do mean experts - you have all been a great help to me in the
endeavor to learn Access!)

 

[Douglas J. Steele]

What information are you storing? In other words, what do your tables look
like?

And while it's a minor point, storing a timestamp might be more appropriate
than an autonumber for sequencing.

 

[Design by Sue]

I don't think a time stamp will work as all portions of the trip are entered
at the same time.

The table includes the following fields (slightly simplified to make this
easier)

Number: an assigned number for the trip
Auto Number: The autonumber field
Point 1: The starting point of the trip (Pick up point for the beginning of
the trip and the drop off for the final - 4th - leg of the trip)
Point 2: The first drop off point ( which becomes the pick up point for the
2nd leg of the trip)
Point 3: The second drip off point (Which becomse the pick up point for the
3rd leg of the trip)
Point 4: The thrid drop off point ( becomes the pick up point for the 4th
leg of the trip)

Hope this answers your question.