This returned anything with out a value in the output field which I already had.
What I really want is to identify the accounts that are in my output field that are not in my report field.
Accounts In Report Accounts in Lookup Field Lookup Output Value
12345 12345 $45.00
45267 45267 $100.01
67431 67432 $44.02
97841 97841 $66.00
I can filter and find all accounts that are in the report & in the look up field & get 4 results.
I can filter and find all accounts that are in the report but not in the look up field & get 1 result.
I want to find account # 98642 which is in the lookup field but not in the report.
I appreciate your help.
Monarch allows you to carry out LEFT OUTER joins from your main table to external lookup tables. This means that it will fetch the data from the external table only for those rows that exist in your table.
You're looking for a RIGHT OUTER join, and the only way to do that is to swap the two tables around. Open your lookup source as your main database in Monarch, then perform a lookup to your data.
Once you do this, the filters Kruncher suggested will help you find the records you need.
Thanks for the confirmation. That was the only way I could come up with but I was hoping to do everything in a single project so that I could more easily turn it over to less knowledgable Monarch users.
I really appreciate everyone;s help.[/quote]
It seems to be more of a data thing than anything Diane.
Set up a batch file if you need to and give the users a single click way to run the process they need to run.
The free Batch File Generator available at [URL="http://www.********************"]www.********************[/URL] should help.