S
Sam yong
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
08 09 10 11 u u u 12 13
0002 01 02 03 u u u u u u u u 04 u
05 06 07 08 09 u u u 10 11
0003 01 02 03 04 05 u u u 06 07 08
u u u 09 10 11 12 13 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 10 11 12 13 u u u
0006 01 02 03 04 u u u u u 05 06 u
07 08 u u u 09 10 11 12 u
Note : I only want to count the total number of ports USED between vintages
0001-0004.And i would like to display the result using ASP.Please help!
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
08 09 10 11 u u u 12 13
0002 01 02 03 u u u u u u u u 04 u
05 06 07 08 09 u u u 10 11
0003 01 02 03 04 05 u u u 06 07 08
u u u 09 10 11 12 13 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 10 11 12 13 u u u
0006 01 02 03 04 u u u u u 05 06 u
07 08 u u u 09 10 11 12 u
Note : I only want to count the total number of ports USED between vintages
0001-0004.And i would like to display the result using ASP.Please help!