QUERY DESIGNED TO MATCH MULTIPE QUESTIONS FOR A NUMBER OUTPUT

I would build a form that allows users to select the criteria, fields, etc
as they desire and then dynamically build a SQL string and apply it to a
saved querydef. That's one of the problems with pulling statistical
information from "flat" tables. You never know what kind of stats users are
going to want.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in message
...
I will forward a copy of it to you via your e-mail. I saw the ATS 2000
you have on the developers web page and that was awesome. I don't think I
am that skilled to do something like that. However I will send what I have
to your e-mail listed on that page.

Thanks Again;

Joe Richardson

"Duane Hookom" wrote:

I had asked if you might provide some sample data records and desired
output/display. Sometimes it takes some effort on your part to provide
the
required information so that we don't have to guess how your tables are
structured and how you want your results to look.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
I could not find the other one today. But the reply that I did get
for
the one on 7/7 was not helpful. I rated the one on 7/7 as not being
helpful.

"Duane Hookom" wrote:

There are responses to this same question in your other threads.
Have
you
replied to those responses?

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
Good Morning,

I NEED HELP. I have a survey form designed and field out by 712
people.
The consist of check boxes for either yes/no answers or multiple
choice
options. Example below: ( [] check boxes or choices )

(1) Gender: Male [] Female[]

(2) Maritila status: Married [] Separated [] Divorced [] Single []

(3) Where do you live: On base [] Off base []

(4) How long lived in area: 1 to 6 months [] 3 to 6 months []
6
mos.to
1 year []

Query needs to identify Male, Married, On base, 3 to 6 months
(Out of
712
people who took the survey).

Please help; if you want a copy of it I can send it via e-mail.
My
e-mail
is .

Thanks in advance.

Thanks for the information. I already have a form built that allows users to answer the survey by clicking on a box to check it. I'm not sure what you mean by a dynamically building a SQL string and apply it to a saved querydef. But I will try to use office assistant to look up the information.

"Duane Hookom" wrote:

I would build a form that allows users to select the criteria, fields, etc
as they desire and then dynamically build a SQL string and apply it to a
saved querydef. That's one of the problems with pulling statistical
information from "flat" tables. You never know what kind of stats users are
going to want.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in message
...
I will forward a copy of it to you via your e-mail. I saw the ATS 2000
you have on the developers web page and that was awesome. I don't think I
am that skilled to do something like that. However I will send what I have
to your e-mail listed on that page.

Thanks Again;

Joe Richardson

"Duane Hookom" wrote:

I had asked if you might provide some sample data records and desired
output/display. Sometimes it takes some effort on your part to provide
the
required information so that we don't have to guess how your tables are
structured and how you want your results to look.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
I could not find the other one today. But the reply that I did get
for
the one on 7/7 was not helpful. I rated the one on 7/7 as not being
helpful.

"Duane Hookom" wrote:

There are responses to this same question in your other threads.
Have
you
replied to those responses?

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
Good Morning,

I NEED HELP. I have a survey form designed and field out by 712
people.
The consist of check boxes for either yes/no answers or multiple
choice
options. Example below: ( [] check boxes or choices )

(1) Gender: Male [] Female[]

(2) Maritila status: Married [] Separated [] Divorced [] Single []

(3) Where do you live: On base [] Off base []

(4) How long lived in area: 1 to 6 months [] 3 to 6 months []
6
mos.to
1 year []

Query needs to identify Male, Married, On base, 3 to 6 months
(Out of
712
people who took the survey).

Please help; if you want a copy of it I can send it via e-mail.
My
e-mail
is .

Thanks in advance.

Joe,
You might want to look at my Query By Form at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
applet can be imported into your application. You would then add a query
named Survey Records with a SQL of SELECT * from YOURTABLE;

You are then exposing your survey results table to a query tool. I doesn't
have a ton of statistics but should give you an idea of what I mean by
dynamically building SQL from selected fields.

--
Duane Hookom
MS Access MVP
--

"Joe Richardson" wrote in message
...
Thanks for the information. I already have a form built that allows users
to answer the survey by clicking on a box to check it. I'm not sure what
you mean by a dynamically building a SQL string and apply it to a saved
querydef. But I will try to use office assistant to look up the
information.

"Duane Hookom" wrote:

I would build a form that allows users to select the criteria, fields,
etc
as they desire and then dynamically build a SQL string and apply it to a
saved querydef. That's one of the problems with pulling statistical
information from "flat" tables. You never know what kind of stats users
are
going to want.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
I will forward a copy of it to you via your e-mail. I saw the ATS
2000
you have on the developers web page and that was awesome. I don't think
I
am that skilled to do something like that. However I will send what I
have
to your e-mail listed on that page.

Thanks Again;

Joe Richardson

"Duane Hookom" wrote:

I had asked if you might provide some sample data records and
desired
output/display. Sometimes it takes some effort on your part to
provide
the
required information so that we don't have to guess how your tables
are
structured and how you want your results to look.

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote in
message
...
I could not find the other one today. But the reply that I did
get
for
the one on 7/7 was not helpful. I rated the one on 7/7 as not being
helpful.

"Duane Hookom" wrote:

There are responses to this same question in your other threads.
Have
you
replied to those responses?

--
Duane Hookom
MS Access MVP


"Joe Richardson" wrote
in
message
...
Good Morning,

I NEED HELP. I have a survey form designed and field out by
712
people.
The consist of check boxes for either yes/no answers or multiple
choice
options. Example below: ( [] check boxes or choices )

(1) Gender: Male [] Female[]

(2) Maritila status: Married [] Separated [] Divorced []
Single []

(3) Where do you live: On base [] Off base []

(4) How long lived in area: 1 to 6 months [] 3 to 6 months
[]
6
mos.to
1 year []

Query needs to identify Male, Married, On base, 3 to 6 months
(Out of
712
people who took the survey).

Please help; if you want a copy of it I can send it via
e-mail.
My
e-mail
is .

Thanks in advance.