[AccessD] Count Query with Memo

Create the query without the memo field. Then create a new query, bring in all of the fields from the count query and join to the table with the memo field. Bring in the memo field.
 
D

 -----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hollis,Virginia
Sent: Wednesday, October 15, 2003 1:20 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Count Query with Memo



What do you do about creating a Count in a query when there is a memo field?
 
I need a count of Assets for a report, but one of the report fields is a memo field.
 
Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031015/15fcadd0/attachment-0001.html>