Replacing duplicates in var

[lauritz]

Hi,

I am using Access97 (I know!) and have a list of values populated from a table. These values represent items with errors. My problem is an item can have multiple errors but I only want to show it to the user once. After I have built my string of items containing errors, is there a simple way to parse it and remove any duplicates??

TIA

 

[PHV]

How is built your string of items containing errors ?
I guess you may consider the DISTINCT predicate in SQL.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Melagan]

Where are these values being listed? In another table, in a query, a report, or something else? If it's a query or report, maybe SELECT DISTINCT in your SQL?


~Melagan
______
"It's never too late to become what you might have been.