Limiting Results

[johnwiseman]

Hi.

I am running the following query. It is pulling in over 2000 results, I only wish to produce the first 50 results which is sorted from the [qry Analysis - Total Errors]TotalErrors desc.

How do I limit the results to the first 50?


SELECT [qry Analysis - Total Errors].Branch, [qry Analysis - Total Errors].TotalErrors, [qry Analysis - A].A, [qry Analysis - B].B, [qry Analysis - C].C, [qry Analysis - D].D, [qry Analysis - E].E, [qry Analysis - F].F
FROM ((((([qry Analysis - Total Errors] LEFT JOIN [qry Analysis - A] ON [qry Analysis - Total Errors].Branch = [qry Analysis - A].Branch) LEFT JOIN [qry Analysis - B] ON [qry Analysis - Total Errors].Branch = [qry Analysis - B].Branch) LEFT JOIN [qry Analysis - C] ON [qry Analysis - Total Errors].Branch = [qry Analysis - C].Branch) LEFT JOIN [qry Analysis - D] ON [qry Analysis - Total Errors].Branch = [qry Analysis - D].Branch) LEFT JOIN [qry Analysis - E] ON [qry Analysis - Total Errors].Branch = [qry Analysis - E].Branch) LEFT JOIN [qry Analysis - F] ON [qry Analysis - Total Errors].Branch = [qry Analysis - F].Branch
ORDER BY [qry Analysis - Total Errors].TotalErrors DESC;


Thanks in advance for your help.

 

[ZmrAbdulla]

SELECT [b]TOP 50[/b]
  [qry Analysis - Total Errors].Branch
  , [qry Analysis - Total Errors].TotalErrors
  , [qry Analysis - A].A
  , [qry Analysis - B].B
  , [qry Analysis - C].C
  , [qry Analysis - D].D
  , [qry Analysis - E].E
  , [qry Analysis - F].F 
FROM
  ((((([qry Analysis - Total Errors] 
  LEFT 
  
  JOIN
  [qry Analysis - A] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - A].Branch) 
  LEFT 
  
  JOIN
  [qry Analysis - B] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - B].Branch) 
  LEFT 
  
  JOIN
  [qry Analysis - C] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - C].Branch) 
  LEFT 
  
  JOIN
  [qry Analysis - D] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - D].Branch) 
  LEFT 
  
  JOIN
  [qry Analysis - E] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - E].Branch) 
  LEFT 
  
  JOIN
  [qry Analysis - F] 
ON [qry Analysis - Total Errors].Branch = [qry Analysis - F].Branch 
ORDER BY
  [qry Analysis - Total Errors].TotalErrors DESC;

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.