Problem with a memo field in a query

[myousman]

Hi folks.

When I construct a query with no criteria (i.e., no WHERE clause), my memo field is output correctly.

However, when I add criteria to the query, my memo field gets truncated (possibly to 255 characters, although I have not made an exact count.)

I need the entire contents of the memo field for a report.

Has anyone run into this, and if so, have you found a workaround?

Thanks in advance.

 

[NaKin]

Don't know if it's proper but it works for me...

Build your query with criteria but omit the memo field. Create a second query from the first query and the table you created the query from. Add your memo field and all the stuff from the first query.

 

[myousman]

Thanks

Thanks for your reply. I will give it a try.