Hi Jason updated query here (I'm using access at the moment)
SELECT tbl_member_language_group.language_group_name, Count(*) AS CountOfcontact_id, tbl_demographics.town, tbl_demographics.region FROM tbl_member_language_group LEFT JOIN tbl_demographics ON tbl_member_language_group.language_group_name = tbl_demographics.language_group GROUP BY tbl_demographics.town, tbl_demographics.region, tbl_member_language_group.language_group_name ORDER BY tbl_demographics.town, tbl_member_language_group.language_group_name ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4