Thanks for a different idea. I am not a 'guru' but an enthusiastic
amateur. I provide the interface for use by others and the 'output'
needs to be simple.
I have never used a pivot table. I will study that and return with
comments and questions.
Robin
At 5/05/2012 02:33 AM, you wrote:
>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
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar