Search results for query: *

Duly Noted, I made the change in the report and it work problem lies now due to the fact I've inserted a field that's not part of the query grouping is off. So control source groups the data but now the report shows the remarks separate once I group multiple records.

Oh I did over the query without the where clause and just utilize the first function and it gave me everything thus far, time now to put in back all those where clause

So is it best to have a where query as the main and a sub query that will reference from the criteria chosen by the user trying to figure what's best so it won't truncate the pstremark

Okay that's weird when it opens I know it will ask for different prompts also the query is the same name as report will upload a different copy tomorrow if problem still occur

Will try this code and see if it works. below is the database link https://drive.google.com/file/d/1Hs5LfprN1WZZbnRq5k4zil8n2I4zj3Ws/view?usp=share_link the report giving the problem is CG-Establishment keep truncating the memo field

No the fields are in the query not in report. If I want to make changes to query access give me the run out memory error. So editing query is complex. So was wondering how to fix the limit given cause its a memo field but report see the expression as a text field

I have a report in ms access where I use a query as it's source the problem i'm having is with the memo field being truncated at 255 character. please note i utilse an expression on the memo field in the query Rem...