Hi everyone,
I have a list box of names in a table, on the report i wish to count the number of names selected in from the list box. for instance i have 20 names to choose from, if i select 5 of them, i would like a text box on my report to show 5.
i have tried using =count(listboxfield) in the control source of the text box on the report but it is not working as expected.
cheers
Richard
I have a list box of names in a table, on the report i wish to count the number of names selected in from the list box. for instance i have 20 names to choose from, if i select 5 of them, i would like a text box on my report to show 5.
i have tried using =count(listboxfield) in the control source of the text box on the report but it is not working as expected.
cheers
Richard