residential question

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

Guest

I have a residential database for a Homeowner’s Association and I’m rather
new at this Access thing. I have created a table with lists of unit numbers,
owner info, and tenant info if the owner doesn’t reside in their unit. I
need to make a query that lists garage numbers with the resident that owns
them. How can I make it to where the column is for residential data- the
person that lives there, rather than listing both the tenant and the owner? I
have a column that says: Owner as Resident and the answer is either yes or
no. Can I use this somehow in the query? Please help and break it down into
simple terms so I can understand where to start. Thanx so much for your help!
 
Hard to give you help when we have no idea what your table structure is.
Tell us more about it so that we can help point you to a solution.

--

Ken Snell
<MS ACCESS MVP>

BVG HOA said:
I have a residential database for a Homeowner's Association and I'm rather
new at this Access thing. I have created a table with lists of unit numbers,
owner info, and tenant info if the owner doesn't reside in their unit. I
need to make a query that lists garage numbers with the resident that owns
them. How can I make it to where the column is for residential data- the
person that lives there, rather than listing both the tenant and the owner? I
have a column that says: Owner as Resident and the answer is either yes or
no. Can I use this somehow in the query? Please help and break it down into
simple terms so I can understand where to start. Thanx so much for your
Click to expand...
help!
 
Thanks Ken. My table has 282 rows with the following columns:
Record #// Condo #// Owner F name// Owner L name// Phone #// O Address//
Tenant name// phone #// Garage #// permit #//...

In my query, I have columns:
Keycard # (or garage #)// Unit// O name// O phone// Tenant name// T phone

but i want Keycard#// Unit// Resident// Resident phone
How can I manipulate the data to give me who lives there?
 
I don't see any field that contains the resident information nor the Keycard
information? What am I missing?

Suggestions: Do not put spaces in field names; better to use consecutive
letters such as KeycardNumber, OName, OPhone, etc. Also, don't use # and
other strange characters in field names, as the # character is a number
placeholder in ACCESS.
 
Try to stick with the same thread instead of posting the same question four
time in two days.....

Did you read my reply to your post 11/4/04 10:51AM? Were you not able to
modify it and get it to work?
Record #// Condo #// Owner F name// Owner L name// Phone #// O Address//
Tenant name// phone #// Garage #// permit #//...
Click to expand...

You nave two fields with the same name (phone #)???? To get the best
help, you should post the actual field names!

You should *still* normalize your table. But this should still give you what
you want; in an empty column of your query enter:
----
Resident: IIF([OwnerAsResident] = "Yes", [OwnerLastName] & ", " &
[OwnerFirstName], [TenantName])

Resident_PH: IIF([OwnerAsResident] = "Yes", [OwnerPhone] , [TenantPhone])
---

I may not be up at Ken Snell's level (or any other MVP for that matter), but
it would be nice to know that you read my reply and if it did or didn't work
(or help you).

OK...end of Rant..... :-)
Whew..got to cut down on that caffeine and get more sleep...

Steve
 
My apologies, Ken. I didn't mean to single you out.... your name was there
and I typed...

I have learned a lot from you, the other MVPs and the other people that take
the time to share knowledge... Thanks for sharing your time know-how.

Steve
 
Back
Top