ASP with Access

[Guest]

There is a card and the card contain different vintage and different vintage
got different number of ports used.My question is would i able to do
calculation in access for vintage 0001 to 0004 if my database look like
this...

Cards Vintages Ports (u=unused)

AUX 0001 01 02 03 04 05 06 07 u u u u
11 12 13 14 u u u 18 19

0002 01 02 03 u u u u u u u u 12 u
14 15 16 17 18 u u u 22

0003 01 02 03 04 05 u u u 09 10 11
u u u 15 16 17 18 19 u

0004 01 02 u u u u u u u u u u u u
u u u u u u u u u u

0005 01 02 03 04 05 06 07 08 09 u
u u u 14 15 16 17 u u u

0006 01 02 03 04 u u u u u 10 11 u
13 14 u u u 18 19 20 21 u

Note : I only want to count the total number of ports USED between vintages
0001-0004.And i would display the result using ASP.Please help!

 

[David C. Holley]

Please post back how the data is stored in the DB. It is possible, but
without knowning the schema of the DB, we won't be able to provide any
additional assistance. And YES, it is possible to create a ASP script to
display the results for assistance with that you'll need the help in
microsoft.public.inetserver.asp.general