By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

duplicate query

P: n/a
Jon
can you use memo fields in a duplicate query?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 27 Sep 2003 01:38:09 -0700 in comp.databases.ms-access,
ca*****@hotmail.com (Jon) wrote:
can you use memo fields in a duplicate query?


No grouping or aggregate functions allowed on them so I guess not.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2

P: n/a
Trevor Best <bouncer@localhost> wrote in message news:<nq********************************@4ax.com>. ..
On 27 Sep 2003 01:38:09 -0700 in comp.databases.ms-access,
ca*****@hotmail.com (Jon) wrote:
can you use memo fields in a duplicate query?


No grouping or aggregate functions allowed on them so I guess not.


True, but you can use calculated fields based on memo fields, e.g.
MyCalcMemo:Left(MemoField,512) gives you the first 512 characters of a
memo field called 'MemoField'.

Bruce
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.