kllatuu it did not help all the way, pl advise again. Thanks

[Mike Saifie]

It did not creat a The only field and lined up all the records from the
list. insted it lined them up all together by record by record,

I want the end result look like his

CAT
DOG
Animals.

The way it showing is

Cat (piked from keyword1)
Cat,(picked from keyword2)
Dog ( Only once, since all the records were inserted in keyword1)


Pl adivsie.

create one field in the query. Then give it an Alias. It would look like
this:
BigGlob: [field1] & [field2] & [field3] & [field4] & [field5] & field[6]
If you want a space after each just add:
BigGlob: [field1] & " " & [field2] & " " & [field3] & " " & [field4] & " " &
[field5] & " " & field[6]
Make it a Totals query, and all rows that are identical will collapse into
one.
If you have criteria for the six fields, but don't want them to show,
unclick the Show check box

 

[Guest]

Please post back with the SQL string from your query.
Open the query in SQL view, copy and paste it to this post.

Also, if you could post the layout for the tables(s) the query is based on,
field names, data types.

I will be happy to look at it.

It did not creat a The only field and lined up all the records from the
list. insted it lined them up all together by record by record,

I want the end result look like his

CAT
DOG
Animals.

The way it showing is

Cat (piked from keyword1)
Cat,(picked from keyword2)
Dog ( Only once, since all the records were inserted in keyword1)


Pl adivsie.

create one field in the query. Then give it an Alias. It would look like
this:
BigGlob: [field1] & [field2] & [field3] & [field4] & [field5] & field[6]
If you want a space after each just add:
BigGlob: [field1] & " " & [field2] & " " & [field3] & " " & [field4] & " " &
[field5] & " " & field[6]
Make it a Totals query, and all rows that are identical will collapse into
one.
If you have criteria for the six fields, but don't want them to show,
unclick the Show check box

In my query that picks 6 fileds ( keyword1, keyword2...... Keyword6,) Now I
also, want to merge them into a singlefiled when I run the same query, and
show them in on line coulum with no duplication.
thanks for your hlep.
Mike