String over 255 characters in a query.

[dealwi8me]

Hello,

i have two questions considering string with lenght over 255 characters.

1) How do i create a string more than 255 characters in a query without trancuted the string?
2) How do i set the type of field in Memo in a query?

Thank you in advance.

 

[HiTechCoach]

Are you grouping (totaling) or using the DISTINCT verb? These will cause any text (field or string) to get truncated.

 

[dealwi8me]

No i just merge several strings into one.

 

[HiTechCoach]

Can you post the SQL for the query(s)?

 

[dealwi8me]

I copied the code into a new query and worked, i don't know what happened :S

Thank you though for your time!

 

[HiTechCoach]

You're welcome!

Good luck with your project ...