ASP with access

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top