I have had to put the project on 'hold' due to other pressurea.
Robin
At 4/05/2012 01:45 AM, you wrote:
>Did you try increasing the row height in the query like I
>suggested? Like I said, by default it will only show the first
>line. Same in Excel, which John has addressed.
>
>Paul
>
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> > 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
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar