T
Traci B........
I have a form with several list boxes. One is for services provided, another
is for county call received, another for referred by, and etc.
I need to be able to count the results of these categories.
When I run my report, these fields are included and I get a long ... cell
of "0"s and "1"s. I realize "0" indicates the first item in the list box was
not selected and the "1" indicates items that were selected. (In some cases,
more than one item can be selected such as services provided.) But, I have
to count over the intergers to see where it is located in the field and then
go count on the form the items in the list box. I know there has to be an
easier way. It is impossible to do it by hand. Note: I do not own the
primary Access program that we import the data from. I cannot alter the form
nor the original table. I link the table to my program and run the data.
It's getting late, so I hope this is understandable as my brain is fried
is for county call received, another for referred by, and etc.
I need to be able to count the results of these categories.
When I run my report, these fields are included and I get a long ... cell
of "0"s and "1"s. I realize "0" indicates the first item in the list box was
not selected and the "1" indicates items that were selected. (In some cases,
more than one item can be selected such as services provided.) But, I have
to count over the intergers to see where it is located in the field and then
go count on the form the items in the list box. I know there has to be an
easier way. It is impossible to do it by hand. Note: I do not own the
primary Access program that we import the data from. I cannot alter the form
nor the original table. I link the table to my program and run the data.
It's getting late, so I hope this is understandable as my brain is fried