I'm trying to run a query to limit the number of records returned. I have a table named "Patient" with "PatientID" as one of the fields. I run this SQL statement and get a syntax error. Any suggestions?
SELECT TOP 25 *
FROM Patient
WHERE key NOT IN (
SELECT TOP 0 [Patient]![PatientID]
FROM Patient
ORDER BY [Patient]![PatientID]);
SELECT TOP 25 *
FROM Patient
WHERE key NOT IN (
SELECT TOP 0 [Patient]![PatientID]
FROM Patient
ORDER BY [Patient]![PatientID]);