Sorting Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry M. Gartner - 17 Jan 2006 21:38 GMT

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.

Signature

Regards,

Jerry M. Gartner

Reply to this Message

Alex Dybenko - 18 Jan 2006 06:41 GMT

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

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Greetings;
>
[quoted text clipped - 4 lines]
> match, just display sorted by field A. Any advice as to how to go about
> this would be most appreciated. Thanks in advance.

Reply to this Message