I have a procedure that creates a query in memory and works on that. However, I know that the select statement should have 13 rows, but when I do a rowcount, it only returns 1.
'Import Score and Personal Info
sSQL = "SELECT * "
sSQL = sSQL & "FROM EmployeeRepApprovalView "
sSQL = sSQL & "WHERE ApprovalHistory.quarter=" & gEvalQuarter & " "
sSQL = sSQL & "AND ApprovalHistory.year=" & gEvalYear & " "
sSQL = sSQL & "AND ApprovalHistory.status='Approved' "
Set rsEmployees = CurrentDb.OpenRecordset(sSQL, dbOpenSnapshot)
intCount = rsEmployees.RecordCount
Forms!frmProcessing.txtItems = intCount
Do While Not rsEmployees.EOF
intItem = intItem + 1
Forms!frmProcessing.txtItem = intItem 'Update count of number of items processed