Boyd, Mark Thomas (US - Philadelphia)
mboyd at deloitte.com
Tue Dec 13 12:54:15 CST 2005
I think the formatting of the report is a bit too complex to change the Record Source to a crosstab query. Setting the detail to dispay in columns might work for what I need to do. Thanks for the suggestions. Mark Boyd Senior Consultant Enterprise Risk Services Deloitte & Touche LLP Tel: +1 215 405 5576 mboyd at deloitte.com www.deloitte.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Tuesday, December 13, 2005 1:37 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Display Data Horizontally You're correct. It's columns in the report. Page Setup -> third tab (Columns). If all you are displaying are the city names, columns will work. If OTH you're trying to display the cities then other data, you'll need to have a sub-report to make the cities display correctly. Jim jhewson at karta.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Tuesday, December 13, 2005 12:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Display Data Horizontally I think that's in page setup. I've done it before. -----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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com