For auditing purposes, I have a a table with 1000 records. I want to filter
for a criteria that gives me 100 records I want to audit, but I only want to
select a sample of 20 lets say. Is there a way I can tell Access to select
every 5th record for example?

Thanks

Derrick,

Pick a key field you can use as a comparison for SomeKey. You may try
something of this sort:

SELECT * FROM (
SELECT (SELECT Count(SomeKey) FROM Audit A WHERE A.SomeKey <=
Audit.SomeKey) AS skCount, OtherField1, OtherField2
FROM Audit
) WHERE skCount mod 5 = 0

Regards,
Vern

On Nov 16, 3:12*pm, "Derrick J" <derr... (AT) noemail (DOT) com> wrote: