Number Query

[rblivewire]

I have a column of numbers contung in order from 1 - 1000. I just need
a query that will show me the results of every fourth number. So 1, 5,
9, 13, etc. Does know how to do this?

 

[Jeff Boyce]

Take a look at the MOD() function. It seems like you could use this as part
of your selection criterion, something like (actual syntax may vary):

where [YourField] Mod 4 = 1

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Use this in a new output column of your query --
x: Int(([YourField]-1)/4)+1

Use this as criteria for that above column --
(([YourField]-1)/4)+1

 

[fredg]

I have a column of numbers contung in order from 1 - 1000. I just need
a query that will show me the results of every fourth number. So 1, 5,
9, 13, etc. Does know how to do this?

As criteria on that line:

[FieldName] Mod 4 = 1

 

[John Spencer]

Field: EveryFourth: NumberColumn Mod 4
Criteria: = 1

That divides the number column by 4 and returns the remainder. Since you want
1, 5, 9, etc., you want those numbers that when divided by 4 leave a remainder
of 1