how to display data horizantaly in Report

[Taher Badri]

Hello

i wanted to ask can i wanted to show my record Horizantaly
in Report.
i have created a report that show that following customer
have audited their account in the following year. e.g

Customer Name
Audited the Accounts for the Year

Mr John 1999
2000
2001
2002
2003

for ur information i have two table name "Main Customer
Table" & other one named as "Customer Audit Table"
my boss wants that the year should come in a single row
like this
Mr John :- 1999/2000/2001/2002/2003

i hope u understand well

Thanking u

Taher Badri

pls reply my ans on (e-mail address removed) also

 

[Duane Hookom]

There is a generic concatenate function with demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane