Combine Table Fields In Query

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
 
M

Mike Anderson

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple data per line 2
Query searching multiple fields 1
Table update using combo box. 3
Combine Duplicates in Query 0
one simple criteria input box - google style 2
Single choice from multiple fields 2
How do I combine the contents of two fields into one in access? 6
Create a table based on another table. 3

Top