Originally posted by r937
select top 50 .... [ rest of query ]
Thanks man. It had been a while sinse I had used access. I saw the dropdown box on the toolbar that lets you select either all records, a certain percentage or whatever number you wanna return. Thanks once again.