G
GMac
I have a report that lists associate certificte completions via checkbox. the
code for the checkbox is: =IIf([Certificate code] In ("TDP0100"),1,0) this
works but if there is an associate with more than one certificate it lists
his name and certificate earned seperate for each one. Is there a way I can
have just his name and all certificates earned in one group: Example
This is what I Want.
John Doe #11111
(checkbox) Certificate 1
(checkbox) Certificate 2
(checkbox) Certificate 3
(checkbox) certificate 4
This is what I get now.
John Doe #11111
(checkbox) Certificate 1 - Checked
(checkbox) Certificate 2
(checkbox) Certificate 3
(checkbox) certificate 4
John Doe #11111
(checkbox) Certificate 1
(checkbox) Certificate 2
(checkbox) Certificate 3 - Checked
(checkbox) certificate 4
Any help would be great!
code for the checkbox is: =IIf([Certificate code] In ("TDP0100"),1,0) this
works but if there is an associate with more than one certificate it lists
his name and certificate earned seperate for each one. Is there a way I can
have just his name and all certificates earned in one group: Example
This is what I Want.
John Doe #11111
(checkbox) Certificate 1
(checkbox) Certificate 2
(checkbox) Certificate 3
(checkbox) certificate 4
This is what I get now.
John Doe #11111
(checkbox) Certificate 1 - Checked
(checkbox) Certificate 2
(checkbox) Certificate 3
(checkbox) certificate 4
John Doe #11111
(checkbox) Certificate 1
(checkbox) Certificate 2
(checkbox) Certificate 3 - Checked
(checkbox) certificate 4
Any help would be great!