I need to convert a series of negative numbers generated by adding the totals of check boxes.
Can I use the Abs function to do so and, if so, how can I do this?
If the Abs function won't work, is there another way of converting these negative totals to positive, either in a query or a report?
I have created an access d'base with approx 40 check boxes for each record.
I want create a query that will add the total number of
boxes checked for each of the 40 options. I have already set up a commencement and end date.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.