R
Rhea
Hi all,
I have two tables: One with Personnel and one with
training. I have had great success with a join query that
works when the common field of WorkCenter has the same
value in both tables. I used a make table query to create
a third table that I use to update the information and
pull reports from.
The problem I have now is that there is some training that
is required by everyone. When I entered the data in the
training table, I used the word all for Work Centers. How
would I join everyone in the personnel table with those
records in the training table that reflect "all"? I went
through the Help section and it says that you can't use
subqueries like that in join tables. I would like to
append the third table with the results so I can continue
to use my current forms and reports.
I have the flu today, so I am a little simple. All help
is greatly appreciated.
Rhea
I have two tables: One with Personnel and one with
training. I have had great success with a join query that
works when the common field of WorkCenter has the same
value in both tables. I used a make table query to create
a third table that I use to update the information and
pull reports from.
The problem I have now is that there is some training that
is required by everyone. When I entered the data in the
training table, I used the word all for Work Centers. How
would I join everyone in the personnel table with those
records in the training table that reflect "all"? I went
through the Help section and it says that you can't use
subqueries like that in join tables. I would like to
append the third table with the results so I can continue
to use my current forms and reports.
I have the flu today, so I am a little simple. All help
is greatly appreciated.
Rhea