Is there a way to calculate and display these in a query? I would like to display the number of days an Incident has been open. Along the same line I'd like to be able to sort by the incidetn urgency's rank, but display the title. Not sure if this is possible in the query designer or this is best handled as a Crysal Report.
Thanks in advance