Goodday all,

Having a difficult time figuring this out. I am working on a windows form with an access back end.

I'd like to get the unique values from a single column in a datatable in a dataset. There are ways that I can pull back rows of information but I only want those values from a single column and only the unique ones.

I have tried the expression function for a datatable but unique or distinct are not recognized words. Nor am I able to build a dataview based soley on the column that I would like, where I would loop to find the specific unique values.

Any ideas?

Thanks


Guy

__________________
Guy

Guy,
Are you saying currently you have a table that doesn't have a primary
key or unique value in one of the fields.
If this is true try adding a new field with AutoNum to increment automatically.

Or you want a unique value coming from a expression / calculation from other field values. If this is what you want you can do is
set an expression from a control/text box prop. in a Form using default value.

Or in a form, under design view, try to create a function/vba code in event tab properties like After Update. This could make you customize
your values to be unique.

Hope this helps.
John

Thanks John, but I guess I was not clear in my message.

In SQL the thing to do would be to say Select Distinct but I just don't want to go back to the data base.

The solution I came up with is to loop through the data and test each item against the previous item in an ordered set this way i can test for uniqueness in the column.

Thanks for the reply.

Now if you have any clear way of updating a database I would love to hear it. But I put that in another post somewhere.

Cheers

Guy

Why reinvent the "distinct" functionality by rewriting when you can just use the logic that already exists in the database?