Hi, I've been back over the lists and I can't find any reference to this, so I'm probably asking a stupid question.
I'm in the process of setting up RT as a replacement to an old (largely broken) in-house ticketing system, coded by a long since gone employee, but I've hit a stumbling block. I need to be able to produce a report each month which shows the full history on any open tickets or any tickets closed in the month. I'm hoping there is something I can do in a query, but the more I fiddle with it, the more my hope is fading and I'm wondering if I need to be looking at a scrip, or perhaps a complex SQL query. I wonder if anyone on the list has already solved this or a similar problem and can point me in the right direction? Regards Stef Stefan Morrell | Operations Director Tel: 0845 3452820 | Alpha Omega Computers Ltd Fax: 0845 3452830 | Incorporating Level 5 Internet [EMAIL PROTECTED] | [EMAIL PROTECTED] Alpha Omega Computers LTD computer network solution providers putting the technology in place that makes your information work for you. Visit our website for more information about how Alpha Omega can enhance your business. IMPORTANT: This E-Mail is confidential and may also be privileged. If you are not the intended recipient, please notify us immediately by telephoning +44 (0) 845 345 2820. Internet communications are not necessarily secure and may be intercepted or changed after they are sent. Alpha Omega Computers LTD does not accept liability for any such changes. If you wish to confirm the origin or content of this communication, please contact the sender using an alternative means of communication. In messages of a non-business nature, the views and opinions of the author are their own and do not necessarily reflect the views and opinions of the organisation. Alpha Omega Computers Ltd, Unit 57, BBTC, Grange Road, Batley, WF17 6ER. Registered in England No. 3867142. VAT No. GB734421454 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com