Transpose Continuous Form to read Top to Bottom

[cardgunner]

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)

           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]

Have you tried using a pivot table?

 

[cardgunner]

No, I haven't.

I'll take a look.

Have you used a pivot table like this before?

 

[SeaRox]

Sorry, I've only played with them, but looking at your code that was the first thing that came to mind.

 

[cardgunner]

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]

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.

 

[cardgunner]

Isn't there a column property?