Memo Truncation in Queries

G

gamer2k4

Hello,

Right now I'm transferring the contents of our company database from
Janna to Microsoft CRM. I'm trying to use a query to put all the
information together, but I'm having a problem. The notes associated
with each contact are long (they're in a memo field in the original
table), but they get cut down to 255 characters in the query result.
Is there a way to make a query field a memo?

Thanks,
Gamer_2k4
 
G

gamer2k4

Never mind, somehow the problem was fixed by changing "total" to First
instead of Group By.
 
R

Rick Brandt

Never mind, somehow the problem was fixed by changing "total" to First
instead of Group By.
Click to expand...

There are several things that you cannot do with a Mmeo field without
truncation occurring. Using GroupBy on them is one.
 

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

disctinct query memo field 3
Unusual reason for Memo truncation 2
memo field in the select query 2
Make Table Query Truncating Memo Field at 255 Characters 2
Force data type from Text to Memo in a simple Make Table Query 1
Totals query and Memo field 3
How can I convert text field to memo field in a query 10
Memo Truncation in Query 2

Top