Help!! Converting memo to text in access

[sandeebee123]

Please help me. I am trying to join two table. However, the column in one table is formatted as text while the other column is formatted as memo. What can I do?

[John_G]

You will have to make them both memo, or both text.

What data is in the memo fields, and how long is it? Remember that text fields can contain a maximum of 255 characters, so that may limit what you can do.

Please provide more information about the data you are working with.