[AccessD] Count Query with Memo

That did it! Thanks.
 
Va.

-----Original Message-----
From: David McAfee [mailto:DMcAfee at haascnc.com]
Sent: Wednesday, October 15, 2003 3:40 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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/f4e12646/attachment-0001.html>