G
Greg
Hi there, I have a table with the following fields:
TripID
LegNumber
LegTown
ArrivalTime
Departuretime
I need to create a query that displays results with the columns:
TripID, Leg1Town, Leg1Arrival, Leg1Departure, Leg2Town, Leg2Arrival,
Leg2Departure,....... etc
I intend to base a form's recordsource on the SQL statement that is
generated. Currently, the forms recordsource is based on a query that gets it
information from other queries. One for each Leg Number. (Each trip has up
to 8 legs). I would prefer to get rid of the queries altogether and have the
forms recordsource as an SQL statement that doesn't make reference to any
queries. Is this possible? If so I would appreciate any help that can be
offered. Thanks!
TripID
LegNumber
LegTown
ArrivalTime
Departuretime
I need to create a query that displays results with the columns:
TripID, Leg1Town, Leg1Arrival, Leg1Departure, Leg2Town, Leg2Arrival,
Leg2Departure,....... etc
I intend to base a form's recordsource on the SQL statement that is
generated. Currently, the forms recordsource is based on a query that gets it
information from other queries. One for each Leg Number. (Each trip has up
to 8 legs). I would prefer to get rid of the queries altogether and have the
forms recordsource as an SQL statement that doesn't make reference to any
queries. Is this possible? If so I would appreciate any help that can be
offered. Thanks!