Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Client records vertically

Status
Not open for further replies.
Haldane

Haldane

IS-IT--Management
Mar 13, 2002
18
0
0
NZ
How do I create a report that will display a clients yearly information side by side vertically?
i.e.
Name
address
---------------------------
2000 2001 2002

sales 1500 2000 2500

 
Sort by date Sort by votes
Hi,
You will want a crosstab report, which is based on a crosstab query. I wrote an FAQ on the basic elements of how to set this up. Please see faq703-2868 HTH, [pc2]
Randy Smith
California Teachers Association
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
104
soloracer
soloracer
Level42Nut
  • Locked
  • Question
Access Subreport repeating records
Replies
2
Views
51
Level42Nut
Level42Nut
SherWat
  • Locked
  • Question
Creating a report with specific records only
Replies
1
Views
35
dhookom
dhookom
stevo1961
  • Locked
  • Question
Printing duplicates records based on number value entered into field 1
Replies
2
Views
47
stevo1961
stevo1961
Roncayenne
  • Locked
  • Question
Group on Product type and skip detail records under product type
Replies
1
Views
21
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top