var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: mod function
how can i enhance this so that i get every 35th record from a table this doesnt seem to work. Any ideas??
SELECT isa_aUDIT.Client_Code, isa_aUDIT.Appellation1
WHERE (((([client_code]+1) Mod "35")="0"));
Did you test
WHERE [client_code] Mod 35=0
WHERE ([client_code]+1) Mod 35=0
ihave tried this but it isnt choosing the records i want.
I have nearly 16000 records on this table but its not selecting from the top of the dataset the 35th then the 70th and then 105th row.
Have i set this up in the wrong way for this to be done.
I made a query and tested it with the next sql
The table contains 60 Records, and the query returns 12 Records
SELECT zz_Geb_BelegArt_COPY.id, zz_Geb_BelegArt_COPY.geb_nr,
WHERE (([id] Mod 5=0));
Records 5, 10, 15, 20 .... 55 and 60