Get the Count of Records From a Query

[MNpoker]

How can I get the number of records from the following?

       VtSQL = ""
        VtSQL = VtSQL & "SELECT QRY_SecondaryDescriptions.Peril_Number, QRY_SecondaryDescriptions.Secondary_Number, QRY_SecondaryDescriptions.Secondary_Value, QRY_SecondaryDescriptions.Secondary_Field, QRY_SecondaryDescriptions.Secondary_Name, QRY_SecondaryDescriptions.Secondary_Value_Name, TempSecondaryQry.CountOfLocID, TempSecondaryQry.SumOfTIVValue " & _
            "FROM TempSecondaryQry INNER JOIN QRY_SecondaryDescriptions ON (TempSecondaryQry." & SecondaryCode & " = QRY_SecondaryDescriptions.Secondary_Value) AND (TempSecondaryQry.Secondary_Number = QRY_SecondaryDescriptions.Secondary_Number) " & _
            "Order By Qry_SecondaryDescriptions.Secondary_Value;"
                  
        Set rst = New ADODB.Recordset
        rst.Open VtSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic

I thought it would be rst.RecordCount but that keeps kicking out a value of -1.

Thanks in advance.

 

[MNpoker]

Got it, what a pain.