469,600 Members | 2,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

pulling data with query

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
Nov 12 '05 #1
2 1430
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


Nov 12 '05 #2
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Philip D Heady | last post: by
4 posts views Thread by Shannan Casteel via AccessMonster.com | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.