[Winmon]

Hello,
I'm new to SQL I am trying to make this "Make Table" query only put out 10 records at a time because the info is going into a form with ten rows. I also want it to select records that have the "return" or are blank in the STATUS column after it finds the location Any help would be greatly appreciated.

Code:

SELECT Count 10 [Tri-County Auto Dealers].[Auto Dealership], [Tri-County Auto Dealers].Address, [Tri-County Auto Dealers].[Owner/GM], [Tri-County Auto Dealers].[Phone Number], [Tri-County Auto Dealers].[New/Used], [Tri-County Auto Dealers].Location, [Tri-County Auto Dealers].[Auto/Boat/Mcycle], [Tri-County Auto Dealers].Salesperson, [Tri-County Auto Dealers].[Service Date], [Tri-County Auto Dealers].Status, [Tri-County Auto Dealers].[Return Date], [Tri-County Auto Dealers].Notes, [Tri-County Auto Dealers].Visits INTO [Tri-County Manifest]
 
FROM [Tri-County Auto Dealers]
 
GROUP BY [Tri-County Auto Dealers].[Auto Dealership], [Tri-County Auto Dealers].Address, [Tri-County Auto Dealers].[Owner/GM], [Tri-County Auto Dealers].[Phone Number], [Tri-County Auto Dealers].[New/Used], [Tri-County Auto Dealers].Location, [Tri-County Auto Dealers].[Auto/Boat/Mcycle], [Tri-County Auto Dealers].Salesperson, [Tri-County Auto Dealers].[Service Date], [Tri-County Auto Dealers].Status, [Tri-County Auto Dealers].[Return Date], [Tri-County Auto Dealers].Notes, [Tri-County Auto Dealers].Visits
 
HAVING ((([Tri-County Auto Dealers].Location)=[Where are you going]) AND (([Tri-County Auto Dealers].[Auto/Boat/Mcycle])="Automobile") THEN (([Tri-County Auto Dealers].Status)="Return")) OR ((([Tri-County Auto Dealers].Status) Is Null));

[bizzar528]

Limit 0,10 I believe.