Sorting Problem

  • Thread starter Thread starter Jerry M. Gartner
  • Start date Start date
J

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.
 
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
 
Back
Top