I am trying to run a query against my database that will average the date/time fields. I have two fields, one is an open date/time and the other is a closed date/time. I would like to be able to select a date range and average the open closed time. In other words, I want to see all tickets for the month of 02/2002 and average the amount of time they were opened. Any HELP! would be very much appreciated.
Thanks
David
Thanks
David