The following is truncating exp_UpdateDateNotes
SELECT tbl_ActionPlanUpdates.fld_ActionPlanNumber, "As of " & [tbl_ActionPlanUpdates]![fld_ActionPlanUpdateDate] & " >> " & [tbl_ActionPlanUpdates]![fld_ActionPlanTargetCloseNotes] AS exp_UpdateDateNotes
ORDER BY tbl_ActionPlanUpdates.fld_ActionPlanNumber, tbl_ActionPlanUpdates.fld_ActionPlanUpdateDate DESC;
is the memo field being truncated in exp_UpdateDateNotes
How can I prevent this truncation?
(Please don't post any links to other workarounds. I'm an auditor, not a programmer. I pay for this service to have my solutions customized and hand-fed to me. I can do my own searches if I'm wanting general answers. I'm not trying to be difficult...just saying, for whichever solution I mark as being correct.)