Rabu, 02 Mei 2012

Re: [MS_AccessPros] Re: Report to Excel

 

The problem starts before the report.

This is my version of your SQL:

SELECT [NameOfClub] & Chr(13) & Chr(10) & [Postal] & Chr(13) &
Chr(10) & [Meets] & Chr(13) & Chr(10) & [PlaceMeet] & Chr(13) &
Chr(10) & [Chartered] & Chr(13) & Chr(10) & [SponsoredBy] & Chr(13) &
Chr(10) & [EmailAddress] AS Entry
FROM qClubs;

I have loaded a screen capture here:

<http://www.rotary9790.org.au/test/test.asp>http://www.rotary9790.org.au/test/test.asp

Robin

At 3/05/2012 09:01 AM, you wrote:
>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
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar