Data from queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am not sure this is can be done. I have a database that has 4 fields
for "person assigned" because of supervisory, etc. I would like to pull all
the records that have to do with that person in all 4 fields. I can pull it
for each individual field in a query, but I need to get all 4 results. I
have tried everything I know, can anyone help?

Thanks
Brian
 
Hi, I am not sure this is can be done. I have a database that has 4 fields
for "person assigned" because of supervisory, etc. I would like to pull all
the records that have to do with that person in all 4 fields. I can pull it
for each individual field in a query, but I need to get all 4 results. I
have tried everything I know, can anyone help?

Thanks
Brian
Click to expand...

Could you explain your table structure a bit more clearly? "because of
supervisory, etc." is unclear to me!

It *sounds* like you have four fields for Person Assigned; if so, you
can use "OR" logic to return a record if the sought-for person is in
any one of the four fields. To do so create a Query in the grid and
put the criterion under each of the four fields, but on *separate*
rows in the query grid.

You may also want to consider restructuring your tables. If you can
have four persons-assigned, someday you will need *five* and your
table won't be able to handle it! It appears that a two-table design
with this table related one to many to a PersonsAssigned table might
be more flexible.
 
Back
Top