pulling data with query

[Michelle]

I have took another approach to my database and have created a field
in my clients table with a 'client status' field, which is a combo
box/value list that is a pulldown menu of 3 choices (active client,
possible client, completed client).

I want to be able to create 3 different queries that will produce a
list that will only publish clients that are active, possible, etc...
(according to whatever the field value is of their status). I am sorry
if this is a rather elementary question but I have been having
troubles grasping the concepts of using a query. Furthermore, in my
clients table, it contains all the necessary client information (name,
address, income, phone number, etc...) and in my 3 different queries,
I will want some information included and some not....for example, in
my active client query, I would not like to have their income reported
in it, but i would want the income to be included on the possible
client list, etc... Is this at a possible, and if somebody could
explain it to me in relatively simple terms, i would sincererly
appreciate it! Thank you very much.

-Michelle

[Tom van Stiphout]

On 20 Apr 2004 02:34:35 -0700, hi*******@msn.com (Michelle) wrote:

Query tab / new query / design view / select your table.
Drag and drop fields from the table to the grid below. For the 'client
status' field, in the Criteria row, type (including double-quotes):
"active client".
Query > Run to see your output.
Save and exit.
You can now use this query as the RecordSource for a form or report.

-Tom.

I have took another approach to my database and have created a field
in my clients table with a 'client status' field, which is a combo
box/value list that is a pulldown menu of 3 choices (active client,
possible client, completed client).

I want to be able to create 3 different queries that will produce a
list that will only publish clients that are active, possible, etc...
(according to whatever the field value is of their status). I am sorry
if this is a rather elementary question but I have been having
troubles grasping the concepts of using a query. Furthermore, in my
clients table, it contains all the necessary client information (name,
address, income, phone number, etc...) and in my 3 different queries,
I will want some information included and some not....for example, in
my active client query, I would not like to have their income reported
in it, but i would want the income to be included on the possible
client list, etc... Is this at a possible, and if somebody could
explain it to me in relatively simple terms, i would sincererly
appreciate it! Thank you very much.

-Michelle

[Tom van Stiphout]

On 20 Apr 2004 02:34:35 -0700, hi*******@msn.com (Michelle) wrote:

Query tab / new query / design view / select your table.
Drag and drop fields from the table to the grid below. For the 'client
status' field, in the Criteria row, type (including double-quotes):
"active client".
Query > Run to see your output.
Save and exit.
You can now use this query as the RecordSource for a form or report.

-Tom.

I have took another approach to my database and have created a field
in my clients table with a 'client status' field, which is a combo
box/value list that is a pulldown menu of 3 choices (active client,
possible client, completed client).

I want to be able to create 3 different queries that will produce a
list that will only publish clients that are active, possible, etc...
(according to whatever the field value is of their status). I am sorry
if this is a rather elementary question but I have been having
troubles grasping the concepts of using a query. Furthermore, in my
clients table, it contains all the necessary client information (name,
address, income, phone number, etc...) and in my 3 different queries,
I will want some information included and some not....for example, in
my active client query, I would not like to have their income reported
in it, but i would want the income to be included on the possible
client list, etc... Is this at a possible, and if somebody could
explain it to me in relatively simple terms, i would sincererly
appreciate it! Thank you very much.

-Michelle