Help please

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

Guest

I am new at this access thing and I don't know if I set this up right, but I
can't figure out the next step. I have a residential database for a
homeowner's association, so I have a primary table with all the info: Owner,
phone number, Tenant (if owner does not reside there), phone number, garage,
permit number, etc... I have developed queries to sort out data according to
garage number or permit number, but I don't know how to show in the resident
slot who lives there. I can only show both sets of owner and tenant and I
can only have the resident. How do I limit this data? Thank you so much for
all your help!!!
 
Comments in-line

BVG HOA said:
I am new at this access thing and I don't know if I set this up right, but I
can't figure out the next step. I have a residential database for a
homeowner's association, so I have a primary table with all the info: Owner,
phone number, Tenant (if owner does not reside there), phone number, garage,
permit number, etc... I have developed queries to sort out data according to
Click to expand...

It sounds like you need to normalize your database. I count you should have
at least 4 tables:

Owner info,
Tenant info,
Permit info and
Property info - (main table)
garage number or permit number, but I don't know how to show in the resident
slot who lives there. I can only show both sets of owner and tenant and I
can only have the resident. How do I limit this data? Thank you so much for
all your help!!!
Click to expand...

If you can't normalize your tables, try this. If the tenant name fields are
empty if owner occupied, in an empty column of your query enter:
(air code - watch for line wrap)

Resident: IIF( IsNull([TenantLastName]) Or Trim([TenantLastName]) = "",
[OwnerLastName] & ", " & [OwnerFirstName], [TenantLastName] & ", " &
[TenantFirstName])

HTH
Steve
 
Back
Top