Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting data from column name

Status
Not open for further replies.

CrystalBart

Programmer
Jun 9, 2004
12
BE
I have created a table simular to this one:

Type A B C
lenght Amount length Amount Cost Amount Cost

10 7 10 4 5 10 9
20 5 6 3 9 8 34
30 ....
...
..
.

I extract the data from a database by filtering the data on the specifications shown on the X and the Y ax. The table is static and always gives an overview of all the possibilities even when there are no records of them Because the table is very big I don't want a formulafield for every cell. Is it possible to extract the filter criteria from the column name and row name so I can create a standard function that will serve all positions in the table? And if so: how?

Any help is most welcome!

CB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top