SteveL13
asked on
Trying to get record cound from sql code
I have this code in the onload event of a form:
strSQL = "SELECT TOP 1 tblPublicationIssuesAndDat es.IssueN"
But then on the form I am trying to get the record count from the above.
I tried this:
me.txtRecCount = Count(strSQL) but that doesn't work.
??
strSQL = "SELECT TOP 1 tblPublicationIssuesAndDat
But then on the form I am trying to get the record count from the above.
I tried this:
me.txtRecCount = Count(strSQL) but that doesn't work.
??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.