Selasa, 01 Mei 2012

[MS_AccessPros] Report to Excel

 

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

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar