Display query results through a form

[wayney2507]

Hi all. I have a simple database set up containing the following:
Origin City, Destination City, Route Code, Price

I have a form set up with two input fields to enter two cities, and a button to run the query based on those entries. This works great so far.

But what I really want is to separate those results by route code. There are typically 50 odd results of the above format, varying over up to 6 different route codes. I want to display each set of results for each different route code separately, without the need to set up a further query on what those route codes actually are.

Please help?

 

[wayney2507]

Ah I've just found this can be done by running a report and just grouping by route code. I guess that does the job Any other simple solutions welcome though!