show only unique fields

[gerjan]

Hello,

I have an Access DB with fields that contains the same name.
Now I only have wan't to display the unique fields from the table.

i.e TABLE =

hardware
hardware
hardware
windows
windows
office

Suposed to display:

hardware
windows
ofice

Is there a code I can put in my SQL string or something to realise this?

[Ribeyed]

Hi,
you use DISTINCT in your select statement:


sqlstr = "SELECT DISTINCT(tblName.FldName), tblName.FldName2 FROM tblName WHERE tblName.FldName = "&whatever&""

hope this helps

[gerjan]

That was easy :)

Tnx

[Ribeyed]

lol, yes it was, but you just need shown the once, but no problem:)