report

[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

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web"

 

[Guest]

thank uou it seem from the module that this what i am looking for, i will
apply it and will give u the feedback