Memo Truncation in Queries

  • Thread starter Thread starter gamer2k4
  • Start date Start date
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
 
Never mind, somehow the problem was fixed by changing "total" to First
instead of Group By.
 
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.
 
Back
Top