Showing Two dimentional data in sub form

[Guest]

I am using Access 2000. will some one plz tell me how to show two dimentional
data on a sub form.

 

[John Vinson]

I am using Access 2000. will some one plz tell me how to show two dimentional
data on a sub form.

Example? What do you mean by "two dimentional (dimensional?) data"?

John W. Vinson[MVP]

 

[Guest]

Example? What do you mean by "two dimentional (dimensional?) data"?

John W. Vinson[MVP]

ok, here is the specimen data that I want to show in the sub form:

ColumnA : ColumnB: ColumnC
1 : 1 : 10
1 : 2 : 20
1 : 3 : 30
2 : 1 : 40
2 : 2 : 50
2 : 3 : 60


I have to show Column A on Y-Axis and Column B on X-Axis. This will become a
2-dimensional data form. Here, in this two dimensional form, I have to show
Column C values.

 

[John Vinson]

I have to show Column A on Y-Axis and Column B on X-Axis. This will become a
2-dimensional data form. Here, in this two dimensional form, I have to show
Column C values.

Use the Crosstab Query Wizard to create a Crosstab query on this
table; display it in datasheet view in the subform.

It won't be updateable - if you want to be able to update the values
of C on this subform it will be a good bit more complex, especially if
there are variable numbers of different B values.

John W. Vinson[MVP]

 

[Guest]

Yes, that’s great. I have used the cross-tabbed query. It works. But I want
editable cross-tabbed sub form.

Please give me some example to further elaborate it. It will be of great
help to me.

- Imtiaz

 

[Guest]

Along with the issue of making the sub-form editable. I also need to change
the contents of the sub form accordingly by changing some control on the
parent form.

e.g.; I have got a combo control on the parent form named "Year". On
changing the year value, I want to show respective records in editable
sub-form.

 

[John Vinson]

Yes, that’s great. I have used the cross-tabbed query. It works. But I want
editable cross-tabbed sub form.

Please give me some example to further elaborate it. It will be of great
help to me.

A crosstab query is NEVER updateable, and cannot be made updateable.

You'll need to either bind the Subform to a temporary table with a
"wide-flat" structure, and use VBA code to migrate the data from that
wide table into the normalized structure (and vice versa), or use an
unbound form with a grid of textboxes (or other controls) and - again
- use code to move data from the table to the form, and back from the
form into the table.

John W. Vinson[MVP]