What exactly is your SQL? Are you sure the rest of it isn't just hidden below? It can be hard to see a multi-line result directly in the query. Try basing a report on that query and either make sure the textbox is long enough to show it or that the Can Grow property is Yes. I tested that and it produced the expected result, but if you just looked at the query you'd only see the first field unless you made the rows taller.
Paul
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
>
> 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