Thank you everyone for your replies. The simple solution was to create the view that returned the date, job number and extended cost.

Mr Celko, I do appologize if posting...