Subject | How to display only the first instance of a value |
---|---|
Author | Terry V. |
Post date | 2005-08-22T18:23:07Z |
Hello,
What I am attempting to do is to ascertain which suppliers in a table have
overdue items on PO's. The way I am looking to do this is to pull the
overdue items and filter the result so that only the first overdue item is
shown for each supplier at which point I'll pull the supplier values into a
string list thus giving a list of suppliers with overdue items. I am unsure
of how to attain this result and would appreciate any assistance.
Regards,
Terry V.
[Non-text portions of this message have been removed]
What I am attempting to do is to ascertain which suppliers in a table have
overdue items on PO's. The way I am looking to do this is to pull the
overdue items and filter the result so that only the first overdue item is
shown for each supplier at which point I'll pull the supplier values into a
string list thus giving a list of suppliers with overdue items. I am unsure
of how to attain this result and would appreciate any assistance.
Regards,
Terry V.
[Non-text portions of this message have been removed]