By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

pulling data with query

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.