Query. Extra column.

[seweryng]

I have a small problem. I’ve enclosed a database to explain it clearly.
I have 3 tables and 3 queries.
3 tables contain data from 2008, 2009 and 2001.
The first and the second query (owner, places) compare data for columns WL_KI and MJS_WID and if value is different return column IsERROR .



Firstly, I don't know how to add another column, let's call is IsERRORdecision, which will have 2 values Yes/No. Combo filed, value list, checkbox? What’s more, default value for isERRORdecision must be the same as for column IsERROR.

Secondly, I’ve created a query (jointly) that gathers information from the first and the second query, but it is impossible to change values from this level in my source tables. Is it doable?


Seweryn

[seweryng]

I reorganised my db so, help is no longer necessary.