[MS_AccessPros] Re: Report to Excel

 

I'd probably use automation, but a simpler method would be to export a query that had a single field:

NameOfClub & Chr(13) & Chr(10) & Postal & Chr(13) & Chr(10) & etc

Untested, but that should create a single field with the data fields vertical.

Paul

--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
> 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
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 1
• New Links 1
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___