How to add column(s) that show Yes or No indicating whether thatrecord came from a related table

[Mike C]

I had to merge three tables together, and now a request has been made
to show (in the merged flat file) in which report the data exists. So
I will be adding three columns, and there needs to be a streaming Yes
or No in each column, indicating whether the Person's name matches to
each file.

Is there a way to do this? I am stumped, but mainly b/c I am new to
Access and am learning how to connect some of these queries to result
in the desired output.

Any suggestions would be appreciated.

 

[Beetle]

I had to merge three tables together

Why? As in why would you want/need to do that? That is completely opposite of
the way Access is intended to work.

and now a request has been made
to show (in the merged flat file) in which report the data exists.

Data doesn't exist in reports, it exists in tables. Do you mean which table it
was in before you *merged* them?

So I will be adding three columns, and there needs to be a streaming Yes
or No in each column

A table can certainly have a Yes/No field, but what do you mean by streaming?
Are you expecting Access to to automagically determine if the field should
be Yes or No?

indicating whether the Person's name matches to each file.

What do you mean by *file*? Do you mean a field in a table?

If you post back with more information, someone may be able to offer
you some advice. On the surface, it sounds like you are creating a
potential disaster.

 

[Allen Browne]

Instead of 3 yes/no fields, just add one 1 field containing the name of the
table the record came from.