Search results for query: *

PH - Slick query (returned the results I was looking for). Can you help me understand the syntax in the WHERE statement, I'm not familiar with the Nz and the peculiar placement of the '' (indicating a non-blank I assume) in the statement. Thanks, Sandcreek

Eupher - Thanks to your direction I came up with a solution that used a query similar to that of the "find unmatched" wizard to facilitate a join with the IS NULL parameter. In order for it to work I had to create a separate table with both Item ID and ITEM_ID in the same table structure and...

Eupher - I have not tried the "Find unmatched" wizard, wasn't even aware of it. Just tried and no luck, I'll play around with it some more. tbl_PAL_Current: ITEM ID Manufacturer's Item ID Description 1000064204 970403-1 FEE 600i ENGINEERING 1000064205 970403-2...

Eupher - Thanks for the suggestion, I tried it and still returns the zero result set. I'll take any alternative suggestions to arrive at th same results, just need to get down to the non-matching rows from the two tables. Thanks, Sandcreek

Hi all - I'm trying to understand an issue I'm having with a particular query and was hoping someone could explain. When comparing fields between two tables, on text field comparison returns results if the two text fields are specified to be equal. However, if I set them to not equal each...