Multiple records to one

Hi all,

I have a database which comprises of a routes system.. some basic fields like

However, I have multiple routes where the Departure and Destination are the same, only the times are different.

How could I make it so that only one appears on the routes list, instead of having about 5 similar entries?

Thanks,

Use GROUP BY in the query.......I'm not sure how to do it on two columns at the same time though.

It could be worse.

There is a whole field of mathematics that deals with this problem. It is called Transportation Theory.

Or you could separate them into 2 tables one for Departure and Destination and one for the times.

There are lots of examples on the net. For example famous quotes. One table of people and one of quotes both linked with PeopleID number.

Regards