How do I sum the number of infinite text answers?

[bhipwell via AccessMonster.com]

Hello,

I am stuck on this one. To illustrate my point, I will use cars as my
example.

I have a text field for which users can enter in anything they want. This
particular field holds the reply to the question "What model car do you own?"
Since there are nearly infinite number of vehicle models out there, I have no
intention of creating a restricted drop down or list box.

Therefore, users can input anything from "Mustang" to "RX 330" to "Countach."
This information pulls into a report that is sorted by location. This
results in a list of drivers located in a particular area of the country
showing each model they drive.

What I need to do is count how many replies equal "Mustang", "RX 330" and
"Countach" understanding that there can be an infinite number of replies.

Any help?

Regards,

BH

(Remember, I am using cars as an example which theorotically can be limited
to a list. In my database, there truly is an unlimited number of answers.)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

[Phil Stanton]

Try

SELECT CarModels.CarModel, Count(CarModels.CarModel,) AS CountOfCarModel
FROM CarModels
GROUP BY CarModels.CarModel;

It should give yo what you want, but meaningless. Even using your example a
Countach will be a totally different car to Lamborghini Countach and
different again from lamborgini Countach. 1 Car - 3 answers. So you could
edit the results manually, or limit the choice with 2 or 3 combo boxes in
the first place.

Phil

"bhipwell via AccessMonster.com" <u30281@uwewrote in message
news:877ee5a6ccedb@uwe...

Hello,

I am stuck on this one. To illustrate my point, I will use cars as my
example.

I have a text field for which users can enter in anything they want. This
particular field holds the reply to the question "What model car do you
own?"
Since there are nearly infinite number of vehicle models out there, I have
no
intention of creating a restricted drop down or list box.

Therefore, users can input anything from "Mustang" to "RX 330" to
"Countach."
This information pulls into a report that is sorted by location. This
results in a list of drivers located in a particular area of the country
showing each model they drive.

What I need to do is count how many replies equal "Mustang", "RX 330" and
"Countach" understanding that there can be an infinite number of replies.

Any help?

Regards,

BH

(Remember, I am using cars as an example which theorotically can be
limited
to a list. In my database, there truly is an unlimited number of
answers.)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

[bhipwell via AccessMonster.com]

Hi Phil,

Thanks for your reply. In regards to having 3 answers for one car, this
actually won't be an issue within the database since the administrator will
be defining the variables per client.

Basically, the database tracks employee benefit programs. One client may
offer three health plans. The health plans can be named an infinite number
of ways. However, one three pre-determined names would be available for the
particular client.

My report now shows a list of all employees and the health plan they are on.
What I am looking for is a way to tell me that X number of employees are on
plan A, X on plan B and X on plan C.

I put your formula in a text box on the report with no success as it is
asking for a parameter value.

Thoughts? Help?

B

--
Message posted via http://www.accessmonster.com

[bhipwell via AccessMonster.com]

My fault,

I added the code to the end of my SQL:

TBLEmployeeInfo.EeHEALPlan, Count(TBLEmployeeInfo.EeHEALPlan,)AS
CountofEeHEALPlan FROM TBLEmployeeInfo GROUP BY TBLEmployeeInfo.EeHEALPlan;

I get the error: Syntax error in query expression

B

--
Message posted via http://www.accessmonster.com

[lyle fairfield]

"bhipwell via AccessMonster.com" <u30281@uwewrote in
news:87fadf83f02ab@uwe:

Basically, the database tracks employee benefit programs. One client
may offer three health plans. The health plans can be named an
infinite number of ways.

Maybe not!

[Phil Stanton]

Where is the "SELECT"

Phil

"bhipwell via AccessMonster.com" <u30281@uwewrote in message
news:87faf6a0851a7@uwe...

My fault,

I added the code to the end of my SQL:

TBLEmployeeInfo.EeHEALPlan, Count(TBLEmployeeInfo.EeHEALPlan,)AS
CountofEeHEALPlan FROM TBLEmployeeInfo GROUP BY
TBLEmployeeInfo.EeHEALPlan;

I get the error: Syntax error in query expression

B

--
Message posted via http://www.accessmonster.com

[Bob Quintal]

"bhipwell via AccessMonster.com" <u30281@uwewrote in
news:87faf6a0851a7@uwe:

My fault,

I added the code to the end of my SQL:

TBLEmployeeInfo.EeHEALPlan, Count(TBLEmployeeInfo.EeHEALPlan,)AS
CountofEeHEALPlan FROM TBLEmployeeInfo GROUP BY
TBLEmployeeInfo.EeHEALPlan;

I get the error: Syntax error in query expression

B

There is a comma that should not be in the snippet below, and you
need a space between the ) and AS
Count(TBLEmployeeInfo.EeHEALPlan,)AS
--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

[bhipwell via AccessMonster.com]

The SELECT is at the beginning of my SQL statement for my query that has many
other statements. The spacing and comma issues have been fixed. Now getting
a syntax error. Thoughts?

B

--
Message posted via http://www.accessmonster.com

[Bob Quintal]

"bhipwell via AccessMonster.com" <u30281@uwewrote in
news:8804385478038@uwe:

The SELECT is at the beginning of my SQL statement for my query
that has many other statements. The spacing and comma issues have
been fixed. Now getting a syntax error. Thoughts?

B

I think, therefore, that unless you copy and paste the SQL that gives
you the syntax error, to the newsgroup, you are wasting bandwidth.

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

[Chuck]

On Thu, 31 Jul 2008 20:44:28 GMT, lyle fairfield <ly******@yah00.cawrote:

>"bhipwell via AccessMonster.com" <u30281@uwewrote in
news:87fadf83f02ab@uwe:

>Basically, the database tracks employee benefit programs. One client
may offer three health plans. The health plans can be named an
infinite number of ways.

Maybe not!

Hopefully not!

Infinite is an undefinable value. If any one of the health plans has a truly
infinite number of ways it can be named, then the sun of that plan is simply
infinite. No calculations required. And therefore the sum of the three plans
together is also infinite. Infinity + 3 + 13 = infinity.

See number of possible permutations in a good math book. The equations are
simple algebra with the possible exception of a term "x!".
If x = 4 then x! = 1 * 2 * 3 * 4 = 24. On a good scientific calculator
there will be a key: x!.

Chuck
--

[Chuck]

On Thu, 31 Jul 2008 20:44:28 GMT, lyle fairfield <ly******@yah00.cawrote:

>"bhipwell via AccessMonster.com" <u30281@uwewrote in
news:87fadf83f02ab@uwe:

>Basically, the database tracks employee benefit programs. One client
may offer three health plans. The health plans can be named an
infinite number of ways.

Maybe not!

My apologies Lyle. My last post under your name should have gone to bhipwell.

Chuck
--