[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1
• New Links 1
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___