Greg Morphis wrote: > Can you do something like... > > select u.mr_no, u.county, count(*) as cnt > from tblUndup u, tblTransactions t > where u.mr_no = t.unitmrnum(+) > group by u.mr_no, u.county > [...] > > Is this what you were looking for? >
Thank you, but it seems to be counting each transaction for the different MR numbers (for me at least). What I'm actually looking for is a count of the MR Numbers, by county, based on their first service date of record. Also, a point I forgot to mention, I'm using MS Access (I know, I know, but it's what the agency has). -- Ms. Judith Taylor Appalachian Community Visiting Nurse Assoc., Hospice and Health Services, Inc. 740.594.8226 http://www.acvna.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
