A
accesshelp
Hi:
I created several tables that have 4 different categories to choose from. I
chose the Yes/No data type for these categories. I then ran a query which
gives me a total for each category. The only problem is that the numbers are
-1 if Yes. I want to be able to generate a report from these tables and want
to calculate a total of all of the categories together and then a percentage
of each category of the total. How can I make that -1 a positive number and
then populate a percentage? I hope that makes sense.
Thanks in advance for you help!
Cindy
I created several tables that have 4 different categories to choose from. I
chose the Yes/No data type for these categories. I then ran a query which
gives me a total for each category. The only problem is that the numbers are
-1 if Yes. I want to be able to generate a report from these tables and want
to calculate a total of all of the categories together and then a percentage
of each category of the total. How can I make that -1 a positive number and
then populate a percentage? I hope that makes sense.
Thanks in advance for you help!
Cindy