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 query output/report.
Any advice as to how to go about this would be most appreciated. Thanks in
advance.

 

[[MVP] S.Clark]

Add the table to a new query, twice. Link field c to field a between the
two.

Add display fields as needed.

 

[Jerry M. Gartner]

I get a blank query return this way. I wasn't specific previously. Let me
clarify what I'm trying to do: 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.

--

Regards,

Jerry M. Gartner