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 - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188015 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54