please help

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

Guest

I have a data base for personal tax clients and business clients.. I want to
make a queries only for business client, the problem is that i select social
security field cause this is my primary key, when i finish the query it shows
me all social security number for business clients as well as tax client. I
just want business clients social security number in my query....please if
any body have any idea.....
 
how do you determine who is a business client vs tax client? You need to
tell the query that.

If you have a field say "type" that contains "tax" for the tax cleints and
"business" for the business clients, you must put that field in your query
and in the criteria put...

="business"


Rick B
 
Well, you haven't told us what field in your table determines whether a
client is a personal tax client or a business client. So, for purposes of
illustration, I'm going to assume that there is a Boolean (Yes/No) field in
the table called IsBusinessClient. A True value in this field will indicate
a business client, a False value will indicate a personal tax client. The
query would then look something like ...

SELECT NameOfSocialSecurityFieldHere FROM NameOfTableHere WHERE
IsBusinessClient = True

In query design view, you would create this by adding the IsBusinessClient
field to the query then typing True on the Criteria row for that column.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Hi taf,

How does your database differentiate tax clients from business clients?
Access isn't smart enough to distinguish which clients are which unless
you specify that information in a field in your Clients table. That's
the field you would set criteria on. Post the SQL of your query &
someone will try to help.

LeAnne
 
I don't have separate business and tax client....some clients are
both.....some are just tax client......i just want to see exact social number
in from of business name....it showing me the whole list of social number....
 
I'm sorry, you're still not giving me enough information to help you. You
want to see the social number from records where ... what? What is it in the
table that determines which records should be shown?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
We can't help you if you don't tell us how to figure it out. Looking at the
records, what characteristic tells you they are the records you want to
pull? Be SPECIFIC. Tell us your table structure (list the fields). Tell
us what a 'desired' record looks like (list every field), then tell us what
an undesirale record looks like (list the fields). Tell us what your query
is currently pulling up (BE SPECIFIC) then tell us what you WANT it to pull
up (BE SPECIFIC) and explain what the difference is.

Rick B
 
Okay
my data base has 3000 record....i have one table that show every field of my
form....like name, address, ss, business name, business address etc
everything thing...now i want to make another table that only show field
regarding business.....i made that table but the problem is that all of my
business client has tax id number as well as social security number.....when
i made business table...it show me all social security number....i just want
those social socurity numbers that related to business name.....i guess
that's specified enough to understand.

Thanks for your time guys.

i really appreciate
 
taf said:
Okay
my data base has 3000 record....i have one table that show every field of my
form....like name, address, ss, business name, business address etc
everything thing...now i want to make another table that only show field
regarding business.....i made that table but the problem is that all of my
business client has tax id number as well as social security number.....when
i made business table...it show me all social security number....i just want
those social socurity numbers that related to business name.....i guess
that's specified enough to understand.
Click to expand...

Obviously not, since no one has replied. You still haven't answered the
fundamental question. HOW does Access know which clients are
business-only clients, and which clients are business + tax clients? For
that matter, how do YOU know which clients are which? To put it another
way, what piece of information do you use to distinguish the records you
DO want to see from those you DON'T?

Again, if you would post the SQL of your query as I requested upthread,
it would make helping you much easier.

LeAnne
 
Back
Top