Hello,
I am makeing a program for the Lotto.
I have a Access 2003 database with fields 0-9, would like to count the number of entries in each field and display in label caption.
Form has Labels 0-9.
cmdCount.
VB Code:
  1. rs.Open "Select COUNT (*) FROM Cash3", cn, adOpenKeyset, adLockPessimistic, adCmdText

  2.         With rs

  3.             lblZero.Caption = rs.Fields("Zero").Value

  4.             

  5.    

  6.         End With

  7.     rs.Close
Can anyone help with this?