residential question

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" wrote in message
...
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!

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?

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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!

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.


--

Ken Snell
MS ACCESS MVP

"BVG HOA" wrote in message
...
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?

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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!

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 #//...

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
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"BVG HOA" wrote:

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?

"Ken Snell [MVP]" wrote:

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" wrote in message
...
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!

grin

Been there, done seen that.....!

--

Ken Snell
MS ACCESS MVP


"SteveS" sanfu at techie dot com wrote in message
...
Try to stick with the same thread instead of posting the same question
four
time in two days.....

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
-----------------------------
Artificial Intelligence
is no match for my
Natural Stupidity

"Ken Snell [MVP]" wrote:

grin

Been there, done seen that.....!

--

Ken Snell
MS ACCESS MVP


"SteveS" sanfu at techie dot com wrote in message
...
Try to stick with the same thread instead of posting the same question
four
time in two days.....

eye twinkle

You're welcome from all of us.

--

Ken Snell
MS ACCESS MVP

"SteveS" sanfu at techie dot com wrote in message
...
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
-----------------------------
Artificial Intelligence
is no match for my
Natural Stupidity

"Ken Snell [MVP]" wrote:

grin

Been there, done seen that.....!

--

Ken Snell
MS ACCESS MVP


"SteveS" sanfu at techie dot com wrote in message
...
Try to stick with the same thread instead of posting the same question
four
time in two days.....