>> 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.
GM> Is it "3" because that was the highest number of times he visited a single GM> property (ie. B was visited the most - therefore the number is "3") or is GM> it because he visited three properties ? sorry - it's three because the client has visited three separate properties multiple times each. make sense? GM> It will depend on what your schema is too. GM> If there is a record per visit then you would probably to a TOP MAX on the GM> number of times they have visited any property (if the former). GM> Or - you would use a DISTINCT on the properties visited and then do a GM> COUNT on that (ie. two queries - or a COUNT query on a VIEW that does GM> DISTINCT). hmmm I'll play with the top max idea, thanks gary. GM> Gary Menzel GM> Web Development Manager GM> IT Operations Brisbane -+- ABN AMRO Morgans Limited GM> Level 29, 123 Eagle Street BRISBANE QLD 4000 GM> PH: 07 333 44 828 FX: 07 3834 0828 GM> **************************************************************************** GM> If this communication is not intended for you and you are not an authorised GM> recipient of this email you are prohibited by law from dealing with or GM> relying on the email or any file attachments. This prohibition includes GM> reading, printing, copying, re-transmitting, disseminating, storing or in GM> any other way dealing or acting in reliance on the information. If you GM> have received this email in error, we request you contact ABN AMRO Morgans GM> Limited immediately by returning the email to [EMAIL PROTECTED] GM> and destroy the original. We will refund any reasonable costs associated GM> with notifying ABN AMRO Morgans. This email is confidential and may contain GM> privileged client information. ABN AMRO Morgans has taken reasonable steps GM> to ensure the accuracy and integrity of all its communications, including GM> electronic communications, but accepts no liability for materials GM> transmitted. Materials may also be transmitted without the knowledge of ABN GM> AMRO Morgans. ABN AMRO Morgans Limited its directors and employees do not GM> accept liability for the results of any actions taken or not on the basis GM> of the information in this report. ABN AMRO Morgans Limited and its GM> associates hold or may hold securities in the companies/trusts mentioned GM> herein. Any recommendation is made on the basis of our research of the GM> investment and may not suit the specific requirements of clients. GM> Assessments of suitability to an individual's portfolio can only be made GM> after an examination of the particular client's investments, financial GM> circumstances and requirements. GM> **************************************************************************** GM> --- GM> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] GM> To unsubscribe send a blank email to [EMAIL PROTECTED] GM> MX Downunder AsiaPac DevCon - http://mxdu.com/ -------------------------------- 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 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
