Left Join Query - URGENT

[darrenhubbard]

I have a table with four fields (call them a b c z) and a very simple query that uses some custom vba functions. The results of this simple query is 8 fields (call them a b c d e f g h).

I've written a Left Join query so field z gets matched into the other query AND so anything that doesn't match remains. This works fine on "perfect" data.

What I need: if there is an entry in the table with a blank field a (but the rest of the fields populated), the Left Join should match to ANY value of a in the corresponding query. I've tried a few things but I can't get it to work! Over to you guys...

Now, it can be pretty flexible -- field a does not have to be blank to indicate that it should match to anything -- it could be the world "ALL" or whatever. Similarly, if there's a better way of doing this other than a Left Join then that's fine too, but I ideally want to avoid an complex vba functions.

Thanks for all your help!

TIA,

Darren

 

[darrenhubbard]

It's OK people. not to worry -- I solved it about two minutes after I posted (and it was more simple than I thought...)