Recent content by spike_access

Perfect @arnelgp, thank you so much! Wouldn't have been able to pull this through without you. Not the first time you've been my hero (and probably not the last one either). Very much appreciated!

Here's a snapshot of the db

Still getting an error when running the query I'm afraid. If I leave the IsComplied without any criteria it works, only when adding False or 0 it errors

Seems like I'm getting either -1, 0 or #Error values in the IsCompliant so when filtering on "False" I get the error. If I remove the "False" it works. Not sure how to filter the non-successful mappings... Tried Not "-1" as filter but that rendered an error.

Hi @arnelgp, As your solution seemed a bit easier I tried that one, but when applying it to my db I get "Data type mismatch in criteria expression" when running the query. I've double checked and all the fields have the same type (short text) so not sure what the reason could be. Any idea? Only...

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...

This is bloody amazing @arnelgp! This is really really helpful - thank you!

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...

Hi both, Thank you for taking time to assist! In the output tab, where the season is blank is the summary of the Show, so basically all episodes in that Show not split up by season. In the 100 foot wave example the episode count 3 is because there's only a season 1 with three episodes, as...

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...

Thank you all for the help! It did the trick @Pat Hartman the data in the tblContentTracker.Audio is two letter language code(s) based on what is deemed the expected languages for a given region. However, the tblQMs.Audio holds ALL available languages to that content. (Yes we're talking video...

Actually, if you wouldn't mind, I do have another question related to these languages. Once I've cleaned the data I need to compare the values to another field which contains language codes. So basically compare the value in tblQMs.[Audio] to the value in tblContentTracker.[Audio]. If all...

This is absolutely amazing! Thank you so much for all the help!

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...