Hi, the group helped me with my last post "Select query from query1 or
query2".
How do I show " JourneyBookingFormQuery.Req ArrTime" on the "Out column in
sortkey" but not in "In column in sortkey" ?
SELECT JourneyBookingFormQuery.ID, JourneyBookingFormQuery.Prefix,
JourneyBookingFormQuery.Surname, JourneyBookingFormQuery.Town,
JourneyBookingFormQuery.Req ArrTime,
JourneyBookingFormQuery.InwardArrivalTime, IIf([input the
date]=[OutwardDate],'Out','In') AS sortkey
FROM JourneyBookingFormQuery
WHERE ((([input the date])=[OutwardDate] Or ([input the
date])=[InwardDate]))
ORDER BY IIf([input the date]=[OutwardDate],'Out','In');
Kind regards, Gordon.