Hi - I'm trying to include certain fields from a following record into query results, based on the values being stored in 2 of the fields. For instance, if table1 has 2 rows where everything is the same, except for the contents in 2 fields, I would want the results of the first row and those 2 fields from the second row to be displayed in 1 row.
Thanks in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.