2 Replies Latest reply: May 15, 2014 10:03 AM by Shannon _ RSS

    Unmatched query

    Shannon _

      Is there a way to do an unmatched query? 

       

      I have a table I bring from an excel file that reports an employees name and the name of the month that they turned in a form for.  I have a master list also in excel that is a list of all the employees that should be turning them in.  Is there a way to compare the list of turned in against the list of not turned in so I can find out who didn't turn the forms in?  I currently do this in access with my summary exports from Monarch, but if I cut one step out, that would be great!

       

      Thanks

       

      Shannon

       

       

      Monarch V9 Pro

        • Unmatched query
          Data Kruncher

          Yes, you can get the end result you're after, but it's a bit of an indirect method to achieve it.

           

          Starting with your master list, build your external lookup to the table that lists the people who have submitted forms. Your list of submitted names needs to have at least one other column, so that you can import a value when you find a match. Even a copy of the names will work just fine with a different field name. Create a field to match the key field, say SubmittedName.

           

          Then if Joe Smith submitted a form, you'll see his name for both the master list and under SubmittedName.

           

          Now build a new calculated Character field to narrow down the ones that haven't yet submitted:

           

          If(IsNull(),"No","Yes")[/code]

           

          Alternatively you could create a Not Submitted filter using:

          IsNull()[/code]

           

          HTH,

          Kruncher