Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mopester
-
How to Sum CheckBox in Query as a Positive #
Got it!! Thanks!!!- mopester
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
How to Sum CheckBox in Query as a Positive #
I'm sorry, I thought I had a little understanding of how to do this, but obviously I don't. I've spent an hour trying to get this to work. I thank you for your help. If you want to spell this out for me, I'd appreciate it. If not, I understand.- mopester
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
How to Sum CheckBox in Query as a Positive #
Where should I put Abs([CheckBoxField]) ?- mopester
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to Sum CheckBox in Query as a Positive #
This is prob so easy, that I couldn't find the answer. I need a Query to search specific checkbox fields and give me the total selected. When I use the Sum in the Query design, I get the results as a negative number. How do I change it to a positive #?- mopester
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
