Convert field to General Number

[newtoAccess]

I have a query that displays my yes/no check boxes. In the query I have fields that would indicate if field = "Yes" set to 1,
This works great. The results shows one field as a check box and the next as a 1. Just as I need.



I now use this query in a report and the 1 show up as "Yes" not a 1. oops
I was trying to print a list where I could show what was flaged 1 then total the field and add that field to other fields.

I can get a sum of the "Yes" field but I can't add two "Yes" fields together as they are text fields.
I tried to set the Queries field to General Number and the report to General number but when I save them they convert back to text fields.

Any suggestions?

[kennejd]

Could you post your sql? I'm thinking you could have a formula field in your query...similar to your 'Yes'/1 calculation, but the new field will have 1s and 0s. Put this on your report and hide it....then try your addition. I may be off on what you're trying to achieve.