Giving a checkbox a value (to export and use for calclations)

[offie]

So I've been working on this big project and part of it is to be able to input data into a form that looks just like the one everyone is using currently.


The thing is that the form is made up of mostly checkboxes:


Eventually I want to be able to do some calulations with this data. The check boxes at Yes/No check boxes which works for the Satisfactory/Unsatisfactory part but I was wondering if I could assign a value to it (ex: 5).

I was thinking of different ways to go about this and was thinking along the lines of using the count function to get some data.

I read on the microsoft page about changing the countrol source with IIF([<fieldname>]=True,"","5"). What is/How do I get to the control source? Would I have to use Yes instead of True because I use yes/no boxes?

If this works to import it into excel or something that would work just as fine too.

Thanks!

[Privateer]

Create a query with this table as the source. Put all the fields in the query. Now put the cursor in the column after the last field. This is where the immediate IF statement goes. You alias the field name and enter a value if the field was checked off.

If you want one field with the checked off value, use the line below. I am assuming that only one check box can be selected per row.
Rating: IIF([Box5]=True,5,iif(Box4=true,4,iif(box3=true,3,iif(box2=t rue,2,1)

If you want five columns with a value in each, the answer is below. You test the field for a true or false value, give it a number, and alias the field name with the AS ???

SELECT tblRating.Question, IIf([Great]=True,5,0) AS GreatValue, IIf([Good]=True,4,0) AS GoodValue, IIf([Average]=True,3,0) AS AverageValue, IIf([Bad]=True,2,0) AS BadValue, IIf([Horrible]=True,1,0) AS HorribleValue
FROM tblRating;

Hope that helps.
Privateer

[offie]

Thanks! Works great.