Need Array Information

[Guest]

I need to make a 2 dimensional array. I was wondering if there is
information anywhere on how to create it, input items in the array and
display items from the array.

 

[Guest]

There is a lot of information in Access Help like changing dimensions,
clearing, creating, declaring, size , using ... You should find everything
you need there.

 

[John Vinson]

I need to make a 2 dimensional array. I was wondering if there is
information anywhere on how to create it, input items in the array and
display items from the array.

What's the context? In a VBA function? Where do you want the data
displayed? Where would the data come from?

And why use an Array (usually used for internal processing in VBA
functions/subroutines) rather than a table?

John W. Vinson[MVP]

 

[Guest]

I want to make a chart with just text. Like this

3| x
2| x
1| x

 

[Ron Hinds]

Look up croostab query in Access Help.

I want to make a chart with just text. Like this

3| x
2| x
1| x

 

[John Vinson]

I want to make a chart with just text. Like this

3| x
2| x
1| x

The simplest way, in Access, would be to have a three-field table with
RowNumber, ColNumber, and Value, and use a Crosstab query.

If you want to actually use an Array and VBA code to generate a
formatted report... good luck. It can certainly be done, but it would
be a LOT of work to do something that can be done very readily using
tables and queries.

John W. Vinson[MVP]

 

[Guest]

Thanks for advise. Could you give me some information on crosstab queries I
have never used them before. Is there a site that expains them?

 

[John Vinson]

Thanks for advise. Could you give me some information on crosstab queries I
have never used them before. Is there a site that expains them?

A Google search discovers lots - frex

www.jmu.edu/computing/ittraining/tutorials/microsoft/access/queries/crosstab.shtml

Also try the builtin Access help for Crosstab; it's pretty clear. Post
back if you have problems with it!

John W. Vinson[MVP]