what dbms? mysql? mssql? oracle? access?
On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska <[EMAIL PROTECTED]> wrote: > I'm looking for a way of obtaining a count of records from a query where > only one particular field has data... > > I don't want to create a separate query for this just addressing this > field (ie. do recordcount where field NEQ "" or some variation) but > would like to utilize an existing query that includes that particular > field already in the select statement (among many others) > > Is there an easy way to get a count of records obtained by a query where > data is in a field I'm interested in > > Hope that makes sense > > Tim > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54