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

How to highlight textbox with the max value

P: n/a
Using A2K. I've developed a survey form with a number of questions
that have 6 possible responses each. The possible values are 5
(Strongly Agree) down to zero (No Response). I want to develop a
report that looks like this:

<Question 1 text>
Strongly Agree Somewhat Agree ..... No Response
<Count of 5's> <Count of 4's> <Count of zero's>

<Question 2 text>
Strongly Agree Somewhat Agree ..... No Response
<Count of 5's> <Count of 4's> <Count of zero's>

<...and so on...>

I want to highlight the response with the highest count for each
question. Any ideas on how to acheive this without going thru a bunch
of if..then's?

Thanks for any help or advice.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You could use a recordset with the following query. (I'm assuming you
have a field for each question containing the answers).
SELECT Q1Answer, COUNT(*) AS NoOfAnswers
FROM Table1
GROUP BY Q1Answer
ORDER BY COUNT(*) DESC
The first record of the recordset will contain the answer most given
for question1. You can then use the OnFormat event to highlight
(change the font for example) of the answer.
ma**********@hotmail.com (Ellen Manning) wrote in message news:<da*************************@posting.google.c om>...
Using A2K. I've developed a survey form with a number of questions
that have 6 possible responses each. The possible values are 5
(Strongly Agree) down to zero (No Response). I want to develop a
report that looks like this:

<Question 1 text>
Strongly Agree Somewhat Agree ..... No Response
<Count of 5's> <Count of 4's> <Count of zero's>

<Question 2 text>
Strongly Agree Somewhat Agree ..... No Response
<Count of 5's> <Count of 4's> <Count of zero's>

<...and so on...>

I want to highlight the response with the highest count for each
question. Any ideas on how to acheive this without going thru a bunch
of if..then's?

Thanks for any help or advice.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.