How do I write a SELECT query to get every fifth record?

[Guest]

I want to write a SELECT query that will give me every fifth record. I have
one on another issue that is a "SELECT TOP 15" and a basic "SELECT COUNT".
What do I have to change in the wording to get every fifth record?

Thanks.

Michael Heiter

 

[Brendan Reynolds]

The answer depends on your definition of 'fifth'. In this example, the
definition is: the value of the sequential number field 'TestNum' can be
evenly divided by five ...

SELECT tblTest.TestNum, tblTest.TestText
FROM tblTest
WHERE ((([TestNum] Mod 5)=0))
ORDER BY tblTest.TestNum;

 

[Guest]

Worked like a charm. Thanks a bunch.

The answer depends on your definition of 'fifth'. In this example, the
definition is: the value of the sequential number field 'TestNum' can be
evenly divided by five ...

SELECT tblTest.TestNum, tblTest.TestText
FROM tblTest
WHERE ((([TestNum] Mod 5)=0))
ORDER BY tblTest.TestNum;

--
Brendan Reynolds (MVP)

I want to write a SELECT query that will give me every fifth record. I
have
one on another issue that is a "SELECT TOP 15" and a basic "SELECT COUNT".
What do I have to change in the wording to get every fifth record?

Thanks.

Michael Heiter