G
Guest
i have a basic Knowledge of access,so any help is Appreciated.
i have a table which part of contents as the following:
employerid No. branch no
123 00
123 02
123 04
222 00
222 03
222 06
6754 00
6754 02
how can print a repot group by employer id no. with branch i.e Horizontal
123 00 02 04
222 00 03
6754 00 02
i have do it with cross tab,then i join them in one text box,but it show a
space for missing value as below
123 00 02 04
222 00 03
6754 00 02
what to do to remove the spaces ? any idea is valueable to me
thanks in advance
i have a table which part of contents as the following:
employerid No. branch no
123 00
123 02
123 04
222 00
222 03
222 06
6754 00
6754 02
how can print a repot group by employer id no. with branch i.e Horizontal
123 00 02 04
222 00 03
6754 00 02
i have do it with cross tab,then i join them in one text box,but it show a
space for missing value as below
123 00 02 04
222 00 03
6754 00 02
what to do to remove the spaces ? any idea is valueable to me
thanks in advance