I'm having a small query brain-fart that I can't seem to overcome. It's not that difficult, but I keep screwin' it up. Given three tables with relationships such as these: *Incidents incID *People personName incID *ToolsUsed toolID incID The tools used will either have some id in it or it will have -5 if no tool was used. For those of you who are undoubtedly about to ask, this data is generated on a national standard, so I can't eliminate the -5; it's far out of my control. What I'm trying to do, in a single query, is to get the percentage of time that no tool was used by each responder. So in the example below, I'd like to have results for John and Sue (together in a single query) showing the percentage of time each didn't use a tool. *Incidents (say the table has incID values of 1 through 9) People John - 1 John - 2 John - 3 John - 4 John - 5 Sue - 6 Sue - 7 Sue - 8 Sue - 9 ToolsUsed (incID-tool) 1 - hammer 2 - -5 3 - wrench 4 - -5 5 - allen wrench 6 - pipe wrench 7 - chisel 8 - -5 9 - -5 So, I'd like to see: John - 40% - 5 incidents Sue - 50% - 4 incidents Thanks, Ferg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4