Recent content by Omo_ekun

I created 2 tables and did a join: one for the scenarios and the second one for the results. I started with 4 scenarios. The query displayed 16 permutation for the 4 scenarios instead of just 4 scenarios with the results.

Thank you all for your replies. @ Pat Hartman, I am interested in your idea. How will I do the left join? P.S I am a newbie with access.

@ MrHans: I have about 20 scenarios. @ plog: I wrote the query to see if it would work before writing the entire 20 scenarios.

Hi all, I need help with the statement below (Access 2007-2010 version). I'm trying to figure out the reason for the error :banghead:: Country Rating: iif([employment]=3 and [income]=2 and [population]=1 and [age]=2, "High", iif([employment]=3 and [income]=1 and [population]=1 and [age]=3...

Hello all, :)