[AccessD] Display Data Horizontally

Charlotte Foust cfoust at infostatsystems.com
Tue Dec 13 11:59:17 CST 2005


Try a crosstab query as the basis for your report.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Boyd, Mark
Thomas (US - Philadelphia)
Sent: Tuesday, December 13, 2005 9:30 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Display Data Horizontally


I need to display a table's data horizontally on a report.
For example, I have the following data in my table:
 
Boston
Philadelphia
Seattle
 
I need the report's detail section to display "Boston, Philadelphia,
Seattle".
 
Any ideas?
Thanks.

Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com <http://www.deloitte.com/> 


This message (including any attachments) contains confidential
information intended for a specific individual and purpose, and is
protected by law.  If you are not the intended recipient, you should
delete this message. 


Any disclosure, copying, or distribution of this message, or the taking
of any action based on it, is strictly prohibited. [v.E.1]
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list