By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,761 Members | 1,879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,761 IT Pros & Developers. It's quick & easy.

How to Read Every 5th record from access query

P: 6
Hi,

My requirement is to read every 5th record from access query between specified time and date interval....please do need full help.
Jul 2 '12 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,366
If you have an autoincrement field, use a mod 5 on that field to return every fifth row.

If not, create a ranking query and use a mod 5 on the rank field.
Jul 2 '12 #2

P: 6
how to create rank query..
Jul 2 '12 #3

Rabbit
Expert Mod 10K+
P: 12,366
You can create a ranking query by joining the table to itself and then using a count.
Jul 2 '12 #4

P: 6
Please give an example..
Jul 3 '12 #5

Rabbit
Expert Mod 10K+
P: 12,366
Sorry, I don't give out code unless the poster has shown an attempt.
Jul 3 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.