Re: In([variable])

On Wed, 31 Jan 2007 00:09:44 GMT, "undrline via AccessMonster.com"
<u28594@uwe> wrote:

I tried it, and it seems like it *will* work, once I get my code straight.
Right now, it's telling me "Join expression not supported."


Ow.

Sorry, but your table design is not properly normalized. If you have
fields Reviewer1, Reviewer2, etc. then you have a "repeating group" -
you're embedding a one (report?) to many relationship in each record,
rather than properly using two tables in a one to many relationship.

I suspect the Join Expression error may be because you have also
fallen victim to Microsoft's Lookup Wizard misfeature: it looks like
you're trying to join a name to a (concealed) numeric ID. Without
knowing the structure of your tables, I can't say for sure though!

John W. Vinson[MVP]
.