Transpose Continuous Form to read Top to Bottom (1 Viewer)

cardgunner

Registered User.
Local time
Today, 13:17
Joined
Aug 8, 2005
Messages
210
I read a few posts on this but nothing definitive on how it's done.

I'm trying to duplicate a present day paper form that my company fills out.

They enter(write out) the info on this form top to bottom.

It's like a crosstab but not quite(I think, never did one in access)

Code:
           Dealer  |   dealer    |   dealer
           AAA         BBB            CCC
year     2000        2000           2001 
make    ford         chevy         Dodge
model   Pinto        Vega          Dart
price    1000        1200            500
value    -10           -20            500

However this form is for entering new records and when I did a crosstab it would not let me.

If this is a huge thing that involves alot of code well then my guys will learn to adapt.

However if it is something achievable for a novice then where do I start?
 

SeaRox

Registered User.
Local time
Today, 16:17
Joined
Apr 1, 2008
Messages
29
Have you tried using a pivot table?
 

cardgunner

Registered User.
Local time
Today, 13:17
Joined
Aug 8, 2005
Messages
210
No, I haven't.

I'll take a look.

Have you used a pivot table like this before?
 

SeaRox

Registered User.
Local time
Today, 16:17
Joined
Apr 1, 2008
Messages
29
Sorry, I've only played with them, but looking at your code that was the first thing that came to mind.
 

cardgunner

Registered User.
Local time
Today, 13:17
Joined
Aug 8, 2005
Messages
210
Well I just tried thru the wizard and it looks alot like a crosstab.

And isn't it for viewing only? Can I edit and add new records?

I have never used one in access. I did a couple in Report Services.
 

cardgunner

Registered User.
Local time
Today, 13:17
Joined
Aug 8, 2005
Messages
210
Hey thanks.

Maybe it is the way. I don't know cause I have never used it.

Before I get entrenched in one way or another I was hoping an expert would show me the correct road if there was one.

I just finished a db where I went down the wrong road.
 

Users who are viewing this thread

Top Bottom