Search results

  1. S

    Solved Comparison with non-matches in query

    Hi, I have a very specific query that I want run in order to identify mismatches. The comparison is to be performed between two tables; tblContentTracker and tblMeta. The key between tblContentTracker and tblMeta is the field MetaID/Meta ID and the comparison should be done between the edit...
  2. S

    Solved Multiple validations - cross values and columns - in one query

    Hi all, Me again with a challenge that gives me gray hairs. Of course I can create multiple queries taking care of one scenario at the time but was hoping for a solution where I don't have to create a million separate queries. I have two tables tblContentTracker and tblMeta in which I want to...
  3. S

    Reporting query

    Hi all, I have a very specific case from which I want to pull reporting data from a database. I have attached an example XLSX with the tab "Data" which represents data from the table, and the tab "Output" with what I want the query/report to create for me. Summary I want to count how many...
  4. S

    Solved Remove duplicated values

    Hi all, I've been browsing through the forum and found loads of examples on how to remove duplicates, but I haven't found a solution that applies to my scenario. If it is out there I apologize if making any unnecessary posting. Could of course be my lack of understanding the posts as well...
Back
Top Bottom