I have a sql query in Access 2010. I am trying to figure out how to pull all records instead of the top 100. Can anyone advise how to alter the current query?
</date()-2)>
Code:
SELECT TOP 100 dbo_Users.FirstName, dbo_Users.LastName, dbo_tbl_PersonnelActive.TSOID, dbo_Transactions.System, dbo_Transactions.OrderNbr, dbo_Project.ProjectNbr
FROM (dbo_Project RIGHT JOIN (dbo_Users INNER JOIN (dbo_Transactions INNER JOIN dbo_WorkOrder ON dbo_Transactions.OrderNbr = dbo_WorkOrder.OrderNbr) ON dbo_Users.SSN = dbo_Transactions.SecID) ON dbo_Project.OrderNbr = dbo_Transactions.OrderNbr) INNER JOIN dbo_tbl_PersonnelActive ON (dbo_Users.LastName = dbo_tbl_PersonnelActive.LastName) AND (dbo_Users.FirstName = dbo_tbl_PersonnelActive.FirstName)
WHERE (((dbo_Transactions.SecClose)>=Date()-3 And (dbo_Transactions.SecClose)<date()-2) (dbo_Users.LastName)="user2" Or="" ((dbo_Users.LastName)="user1" AND="" ))
GROUP BY dbo_Users.FirstName, dbo_Users.LastName, dbo_tbl_PersonnelActive.TSOID, dbo_Transactions.System, dbo_Transactions.OrderNbr, dbo_Project.ProjectNbr;