A
alex
I'm trying to create a query based on two tables.
The first table (tbl1), populated via a form, is filled with several
generic text columns and about 12 yes/no datatype columns named A,B,C,...
etc.
I named these columns A,B,C, ...etc., because they stand for something
else and I couldn't fit that something else into the column headings.
So, e.g., If column A has a check, or a yes, it means a yes to
particular question/response.
I now have another table (tbl2) that I'm trying to marry to tbl1.
Tbl2 has the information that relates to what column A,B,C, ...etc.
actually means.
What I'm trying to do is create a query that will bring these two
tables together. I can keep all of the column headings in tbl1, but
instead of the yes/no response, I want it replaced with a record in
tbl2...something like this: iif([A] = yes, [some value in tbl2], null).
Keep in mind that I can manipulate tbl2 however I want-it's not that
big.
If this is impossible or a complete head scratcher, I could program my
form to populate the specific value (instead of a yes/no) based on the
response from the user; e.g., if a user checks the box then 'some
value' is populated else null, instead of a yes/no value. I didn't
research how to do this initially because I didn't want my table to be
too cumbersome.
Thanks for any thoughts.
alex
The first table (tbl1), populated via a form, is filled with several
generic text columns and about 12 yes/no datatype columns named A,B,C,...
etc.
I named these columns A,B,C, ...etc., because they stand for something
else and I couldn't fit that something else into the column headings.
So, e.g., If column A has a check, or a yes, it means a yes to
particular question/response.
I now have another table (tbl2) that I'm trying to marry to tbl1.
Tbl2 has the information that relates to what column A,B,C, ...etc.
actually means.
What I'm trying to do is create a query that will bring these two
tables together. I can keep all of the column headings in tbl1, but
instead of the yes/no response, I want it replaced with a record in
tbl2...something like this: iif([A] = yes, [some value in tbl2], null).
Keep in mind that I can manipulate tbl2 however I want-it's not that
big.
If this is impossible or a complete head scratcher, I could program my
form to populate the specific value (instead of a yes/no) based on the
response from the user; e.g., if a user checks the box then 'some
value' is populated else null, instead of a yes/no value. I didn't
research how to do this initially because I didn't want my table to be
too cumbersome.
Thanks for any thoughts.
alex