Combine Table Fields In Query

  • Thread starter Thread starter JCrowe
  • Start date Start date
J

JCrowe

Hi All,
I have a table that recieves input thru a web form. The
fields are called:

Keyword1
Keyword2
Keyword3

My problem is over a period of time duplicate Keywords
have been entered into the table.

I would like to create a query that will combine the 3
table fields into 1 keyword field then supress duplicate
entries.

Thanks,
JCrowe
 
Just create distinct query on each of the three field then
append the distinct result sets into one field.

Mike
 
Back
Top