Thanks Paul,
Does not work for me. It shows only the first field in the result.
Robin
At 2/05/2012 09:19 AM, you wrote:
>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
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar