HELP! 1 Field 2 Tables ?

[Riks]

Is it possible to have values manipulated and filled in 1
Query field from 2 different tables. Since these two
tables have the same field (amt) which are linked together
by an (ID). I want to show in the Query of this amt field
from either of the Tables where if 1 table has the value >
0 then that value should be picked up else from the
default table. Is this possible?? I don't want to create 2
different fields in the Query with 2 different fields.

Any suggestions would be welcome. Thanks in advance

Riks

 

[John Vinson]

Is it possible to have values manipulated and filled in 1
Query field from 2 different tables. Since these two
tables have the same field (amt) which are linked together
by an (ID).

This is a violation of normal form. Storing the amt field redundantly
is not a good idea - if you have two Amt fields (and if they are in
two tables the *are* two different fields), then there is no easy way
to ensure that they remain the same!

Store the amt in one table. Use Queries to look it up when you need
it. That's what relational databases are *for*.