Rabu, 02 Mei 2012

RE: [MS_AccessPros] Report to Excel

 


John,

I am producing a result for less computer savvy users and that would
not be acceptable. I need a simple 'click this button' option.

Robin Chapple

At 2/05/2012 05:03 PM, you wrote:
>Robin-
>
>Export to Word, highlight the data in Word and choose Insert / Text / Convert
>Text to Table. Copy the resulting table into Excel.
>
>John Viescas, author
>Microsoft Office Access 2010 Inside Out
>Microsoft Office Access 2007 Inside Out
>Building Microsoft Access Applications
>Microsoft Office Access 2003 Inside Out
>SQL Queries for Mere Mortals
>http://www.viescas.com/
>(Paris, France)
>
>----------------------------------------------------
>
>From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
>Sent: Tuesday, May 01, 2012 11:06 PM
>To: MS_Access_Professionals@yahoogroups.com
>Subject: [MS_AccessPros] Report to Excel
>
>
>I have a club report with this SQL:
>
>SELECT qClubs.NameOfClub, qClubs.Postal, qClubs.Meets,
>qClubs.PlaceMeet, qClubs.Chartered, qClubs.SponsoredBy, qClubs.EmailAddress
>FROM qClubs;
>
>I have made a report where the data shows as:
>
>NameOfClub
>Postal
>Meets
>PalceMeet
>CharteredBy
>EmailAddress.
>
>I need an XLS version in that format.
>
>If I use 'Export' the data shows in the format:
>
>NameOfClub, Postal, Meets, PalceMeet, CharteredBy, EmailAddress.
>
>How do I arrive at an Excel output in the vertical list format?
>
>Many Thanks,
>
>Robin Chapple
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar