sum combo box value in detail section of report

[nanny]

Anyone up for a challange or a good laugh???
I am working on a DB to be used by our corporate compliance auditors. I have multiple tables,queries and forms. I have a report with multiple questions each question was assigned a default numerical value (points). I have combo boxes that display "YES", "NO' or "N/A', next to the combo box I have a text box that that will display the points if the question is answered "YES". I need to total the text boxes that have a numerical value displayed (points) per chart. If anyone can follow my line of thinking and offer any advice, I certainly would appreciate it.
Thanks in advance,
Nanny

 

[statsman]

I can understand why you would use a combo box to enter this data into your database.
With only 3 possible answers (Yes, No or N/A) I don't see any advantage to setting the report parmaeters using a combo box.

Having said that, I would create a search form with the Combo box. In the criteria of the query which runs the report, use the combo box selection as the criteria.

 

[nanny]

Thanks for your reply. Being self taught has many, many, many "I'm not sure why, it just worked. My logic was I am developing a DB with many forms that will have several hundred questions that will only be answered, YES, NO or N/A. I'm not sure what you mean by search form. After discussing my problem with someone who is a little more knowlegable ,my problem is not as simple as I thought. My Report is a multiple column subreport and I will need to sum each column--I need code to say question 1-is worth 4 points if the answer is yes store 4 points, question 1 is worth 4 points if the answer is No store 0 points, question 1 is worth 0 points if the answer is N/A store 0 points- I am sure this must sound pretty crazy to someone who has extensive knowledge. Thanks again for your reply.

 

[boblarson]

You shouldn't be using a combo box on a report. You would use a text box to display what you want from the value. But a combo has no meaning on a report as it is not interactive.

 

[nanny]

I needed the report Yes,No or N/A to be visible. When I changed the combo box to a text box on the report all I could get to display was a number. I did try.

 

[boblarson]

I needed the report Yes,No or N/A to be visible. When I changed the combo box to a text box on the report all I could get to display was a number. I did try.

You don't understand that the number is what is stored in the table. So, you have to include the lookup table in the query for the report and then use THAT field instead of the field in your storage table.

 

[boblarson]

If you include the database here, we can show you what we mean.

 

[nanny]

I'm not sure how to post my DB

 

[boblarson]

I'm not sure how to post my DB

Sorry, I almost included this in my last post. I guess I should have:
http://www.access-programmers.co.uk/forums/showthread.php?t=140587