Have you considered using a pivot table in Excel and pulling the data in with MS Query? Add all of your fields as row labels and suppress subtotals.
Randall
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
>
> 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