Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Displaying Records Horizontally

Displaying Records Horizontally

Displaying Records Horizontally


I need to create a report where the records display vertically instead of the traditional horizontal. The query the report needs to be based off of is something like this.

Date Sales Orders Calls Rec Calls Abd
4/1 $12 2 13 3
4/2 $84 4 25 1
4/3 $99 5 10 2

I need the data to be displayed like

4/1 4/2 4/3
Sales $12 $84 $99
Orders 2 4 5
Calls Rec 13 25 3
Calls Abd 3 1 2

(Sorry, the example is bunching up when I post this.) I have tried a couple different ways with no luck. The report will be run weekly and display seven days across the page.

Any ideas?

Thank you so much



RE: Displaying Records Horizontally

Is that what you wanted to show?

Date Sales Orders Calls_Rec Calls_Abd
 4/1  $12    2     13          3
 4/2  $84    4     25          1
 4/3  $99    5     10          2
I need the data to be displayed like

            4/1 4/2 4/3
 Sales      $12 $84 $99
 Orders       2   4   5
 Calls_Rec   13  25   3
 Calls_Abd    3   1   2 

If so, use Pre TGML tag (use Preview to check before you post)

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: Displaying Records Horizontally

Hi, that is it exactly!!! Any ideas?




RE: Displaying Records Horizontally

I would use a main report based on every unique Sunday (or Monday or whatever). Add a text box txtDay0 in the detail section with a control source of the date field. Then add 6 more text boxes across the detail section with control sources of
Name= txtDay1
Control Source =txtDay0+1

Name= txtDay2
Control Source =txtDay0+2

--- etc ---
Name= txtDay6
Control Source =txtDay0+6

Create a small subreport that has the daily format the way that you want. Add 7 copies of the same subreport, one under each of the date text boxes. Set the link master to the appropriate txtDay[N] and [Date Field] (it's not really named Date is it?).

You can add a single copy of the labels on the far left of the main report detail section.

Hook'D on Access
MS Access MVP

RE: Displaying Records Horizontally

What you're saying is you need a spreadsheet!lol

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close