Problem with columnar reports

  • Thread starter Thread starter im99_chs via AccessMonster.com
  • Start date Start date
I

im99_chs via AccessMonster.com

Dear friends
I have a problem with columnar reports in access. I want to report in
columnar type of report results from a database but instead of having :

Name Christos Tom Nick James
Surname Pan Xiang Grets Hilat
ID 22 33 44 55
Password 123 456 789 000
mail fsd@ sdfs@ f54@ 65k@
date of birth 1/1/1979 1/1/1979 1/1/1979 1/1/1979

I have these results
Name Christos Name Tom Name
Nick Name James
Surname Pan Surname Xiang Surname
Grets Surname Hilat
ID 22 ID 33
ID 44 ID 55
Password 123 Password 456 Password
789 Password 000
mail fsd@ mail sdfs@
mail f54@ mail 65k@
date of birth 1/1/1979 date of birth 1/1/1979 date of birth
1/1/1979 date of birth 1/1/1979

How can I remove the between columns which are the same as the first?????

Thanx in advance
Christos
 
im99_chs via AccessMonster.com said:
Dear friends
I have a problem with columnar reports in access. I want to report in
columnar type of report results from a database but instead of having :

Name Christos Tom Nick James
Surname Pan Xiang Grets Hilat
ID 22 33 44 55
Password 123 456 789 000
mail fsd@ sdfs@ f54@ 65k@
date of birth 1/1/1979 1/1/1979 1/1/1979 1/1/1979
Click to expand...

Access is really designed to give you the data this way:

Name Surname ID Password mail Date of
Birth
Christos Pan 22 123 fsd@
1/1/1979
Tom Xiang 33 456 sdfs@
1/1/1979
Nick Grets 44 789 f54@
1/1/1979
James Hilat 55 000 65k@
1/1/1979

Tom Lake
 
Back
Top