Tri-dimensional array -> bi-dimensional reports (grid)?

  • Thread starter Thread starter Patrick Cormier
  • Start date Start date
P

Patrick Cormier

hello,

If I have set-up a tri-dimensional data array in Access as follows:

- one table contains the array fields with three foreign keys, each foreign
key pointing to a lookup table representing the cube axis (e.g. Business
Units, Activities, Capacity checks);
- this table with array elements contains two fields: one with text and one
contains a number (1-6);

....How can a build a report in Access that, for each Capacity check value,
would present a bi-dimensional cross-section of the cube, i.e. a grid with
one axis being business units,the other being activities and the grid cell
being the array value (either the text or number - not both)?

I'm used to designing reports in Access that show information sequentially
but never built a report in a "grid" format, I was wondering if it is
possible.

Thanks -

patrick
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You could be talking about cross-tab queries, aka Pivot Tables, if you
want the datagrid to show a Sum, Count, Avg, etc. of the array value.
Read the Access Help article on cross-tab queries, create one and then
create the report using the cross-tab query as the report's
RecordSource.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQB2Q1IechKqOuFEgEQJc4ACfXkxTh1soL3quh8Bg4JSxjc7Xk4YAnRQ3
wlf6jIzsEpxgCZTOGEGurm8k
=ZQS5
-----END PGP SIGNATURE-----
 
Back
Top