Hi All,
I have a mildly tricky one for you - the english explanation of
what I want to do is as follows:
when a client inspects a property, a record is created. What I
need returned, is a count per client, of how many times they've
inspected properties more than once. For instance:
the client has inspected property A twice, property B three times,
and property C twice. The count of multiple inspections should
come back equalling 3.
this make sense to anyone? I'm positive I've seen or perhaps even
done something like this before, but I can't for the life of me
remember how to achieve it. Any help would be greatly appreciated
;)
cheers,
Toby
--------------------------------
Life is Poetry,
write it in your own words
--------------------------------
Toby Tremayne
Cold Fusion Developer
Code Poet and Zen Master of the Heavy Sleep
Virtual Tours
+61 416 048 090
ICQ: 13107913
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1652
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
Get the mailserver that powers this list at
http://www.coolfusion.com
