8 Replies Latest reply: Mar 21, 2013 1:08 PM by Gysbert Wassenaar RSS

    selecting un-selected records?

      Hey guys. Need your help.

       

      I'm creating a QV chart to show all consultants that have submitted time sheets for a given week.

       

      I have a table box (called "submitted") that has a list of consultant names. I then have a list box, which allows you to select a particular week-ending date. This will (obviously) filter the consultant names in the "submitted" table by consultants that have submitted a timesheet for that particular week-ending date.

       

      Is there a way to create another table, which shows which consultants did NOT submit a timesheet for the week-ending date that was selected? In other words, a table that shows which consultants dropped off the "submitted" table, when I selected the week-ending date?

       

      Thanks!