Access97 - Concatenating 4 memo fields?

[Guest_imported]

I've tried various queries to combine 4 fields into one, into a new table. This is not working, well, it works but it cuts off the end of the line once it reaches 255 characters. So, I made each field a memo field as well as the one I'm trying to dump the combination into. It gives me an error saying something like "Can't include Memo or OLE objects when selecting unique values." How can I do this? Again, combining 4 fields into 1 but will have to be a memo field and it will have to be using an append or make table query (preferably make table if possible). Thanks in advance for any help or attempts.

 

[RickSpr]

Make a SELECT query with all your criteria in it, and with Unique Values set. Then make a MAKE TABLE query on top of it WITHOUT Unique Values, and join the tables that contain the memo fields. Construct an expression concatenating the memo fields as the source for the output table's memo field.

The SELECT query with unique values will eliminate the duplicates for you, and doesn't have the illegal memo fields in it. The MAKE TABLE query adds the memos to the already unique rows. Rick Sprague