Access Newbie Query Question

  • Thread starter Thread starter Wendy L
  • Start date Start date
W

Wendy L

Windows XP
Office XP

I am trying to develop a query from 3 tables. The first table has fields:
FarmNo, Tract, Map. The Second Table has data for farm "operators" and
contains fields: FarmNo, Idnum, Idtype. The third table is almost identical
to the second except that it has data for farm "owners" with the same fields
as Table2; FarmNo, Idnum, Idtype. A farm may have an operator and a seperate
owner or may have the same operator/owner.

How would i develop a query from these 3 tables that will give me the name
of the name and idnum of the operator as well as the name and idnum of the
owner on a seperate line. For example, if FarmNo 16 has Joe Farmer as
operator and shows Joe Farmer and his wife, Betty Farmer as the owners of
the farm, how would i set this up and link data so that there are seperate
lines of data for Joe Farmer - Operator, Joe Farmer - Owner, and Betty
Farmer - Owner.

Thanks for in advance for any help provided to a total Access newbie.
 
I'd combine the second two tables into one, since they have an identical
structure. Add two extra boolean fields - one for "owner" and one for
"operator".
 
Adding the fields is simple enough - just open the table in design view and
create two new fields. Set their data type to yes/no (the same as boolean),
give them suitable names and save the table.

If you've already got data in your database, or designed queries and forms
around your current table structure, then the more difficult job will be
combining the two tables and altering the queries etc to match the new
structure!
 
Back
Top