Memo Field and Total

[doran_doran]

I am using a query for a report. But the query is total and memo field is not allowed in the total query.

Method1: NOT WORKING
I used left function on memo field.
Notes: Left([note],255), even if i change the 255 to 99999 it only picks up first 255 characters.

Method2: NOT WORKING
I can't even do a dlookup on my report so i can display the memo field with full length.

None is working
=DLookUp("([Note])","tblNotes","[txtNotesAutoID] = '" & [NotesAutoID] & "'")
OR
=DLookUp("([Note])","tblNotes","[txtNotesAutoID] = '" & Reports![rptPlanNotesTop10]!NotesAutoID & "'")

Anything I am missing ???

 

[KenHigg]

How could you can aggregate memo's. If you do a totals query, each row would represent severals rows from the original table(correct?), from which record would the memo data come from?

Can you post a sample?

???
ken

 

[doran_doran]

Thanks....

Thanks everyone for your effort. I followed Pat's suggession and it worked. Thanks to Pat....

http://www.access-programmers.co.uk/forums/showthread.php?t=10972&highlight=change+memo+field