SQL Query help needed

[Jaspal]

Hi guys,

i have an access table with the following fields Name,p1,p2,p3

p1,p2,p3 are the preferences.

a user can have an entry in the table with his name & preferences in any order.

What i need is to fill u pa combo box with the Unique preferences from p1,p2,p3.

repetetions cannot occur in a single row but they may occur in a column.

Any help will be welcome.

Regards
Jaspal

[raicheman]

I would error check the p1,p2,p3 fields before writing the data.
If p1 = p2 then nodatawritten
elseif p1 = p3 then nodatawritten
elseif p2 = p3 then nodatawritten
else
write data
end if
I don't know of a way to error check w/sql.
Hope this helped