Value for Yes/No Check Box

[lansel]

I have a form whereby there is a yes/no check box. The box is checked if a die change was made in printing the labels. I want to be able to calculate the die change by 20 sheets of paper to come up with a waste calculation every time there is a die change. If I put in the criteria of true and then a count calcualtion in the query I only have the lines in the table that has a yes. I want all the entires displayed when I run the query, but only have the count in the entries that have a yes.

I know this is rambling and probably doesn't make sense.

Table

Date Operator Machine Client Die Change Count
9/4/12 McBee xl Jones CK 1
9/4/12 Clark xl Wilson No Ck

Your help would be greatly appreciated.

Thanks!

 

[spikepl]

I know this is rambling and probably doesn't make sense.

Quite.

Show some data, and the corresponding resulting data. You may want to use the code brackets for formatting the data ( Edit Go Advanced->select text to be formatted as code -># )

 

[lansel]

Sorry for the rambling. Sometimes it is hard to explain what you want to do when you really don't know for sure if it can be done.

What I am trying to do is I want to return a "1" in a query when the answer is yes. The form I have is bound to a table and the form has a check box for yes/no. Yes then appears in the table. I will use that table to run a query and I will use this query to calculate waste based on the yes answer.

But, I want all the entries from the table in the query, not just the "yes" entries.

I hope this makes better sense. Can this be done easily?

Thanks,

 

[YNWA]

Are you specificing in your query to bring back only YES ansfers for that field?

 

[lansel]

If I use the criteria "true", then it brings back all the yes answers in the query.

I then need a calculation. Each of the yes answers would be multiplied by 20. I thought it would be easier for calculation purposes to have the yes equal a "1" but I don't know how to do that.

Thanks!

 

[jdraw]

A checkbox has values -1 if Checked (True) 0 if unchecked (False)

 

[YNWA]

Sorry I dont get it.

So each row that has a 1 in the Die column needs to be x20?

If do new colum in query Test:[DieColumn]*20?

 

[lansel]

Thanks for your help. I finally managed to come up with the results I wanted but creating some queries.

Basically I put in the criteria true in a query and then make another query for the count. I was able to create a report then for the calcuations. I'm sure it wasn't the best way.

Sorry for all the confusion