[AccessD] Memo Fields and Reports in Access 97

Mackin, Christopher CMackin at Quiznos.com
Wed Apr 28 15:40:50 CDT 2004


It's limited when used with a GROUP BY or DISTINCT SQL statement as the
recordsource.  All you need to do is, if you require DISTINCT OR GROUP BY,
leave the PK to the Memo field in that query, then, at the highlest level of
your query link back to the Memo field and grab it there.

Chris Mackin

-----Original Message-----
From: Jeff Barrows [mailto:Jeff at outbaktech.com]
Sent: Wednesday, April 28, 2004 2:23 PM
To: AccessD
Subject: [AccessD] Memo Fields and Reports in Access 97


It has been a while since I needed to add a memo field to a report and I
cannot seem to remember, is the memo field limited to 255 char. on the
report?  And if so, could it then limit my memo field to the same 255 chars?

 

TIA

Jeff Barrows  

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list