Sorting Problem

[Jerry M. Gartner]

Greetings;

I have a table with fields A, B, and C. If field C in record 7 = field A in
record
1 or field C in record 7 is like field A in record 1, I would like the
records to be displayed next to each other in the output/report. If no
match, just display sorted by field A. Any advice as to how to go about
this would be most appreciated. Thanks in advance.

 

[Alex Dybenko]

Hi Jerry,
well, the only solution I see so far - is to build a temporary table, and
then fill it with values from A, B and C in code by opening recordset, going
through it and saving value in appropriate record of temporary table

perhaps anybody else has better solution