Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
functions:equivalent_of_mod_function_in_ms_access [2017/02/07 16:36]
metecuma
functions:equivalent_of_mod_function_in_ms_access [2017/02/07 16:37]
metecuma
Line 14: Line 14:
 RESULT: [YOUR_NUMERIC_FIELD]-(MOD_BASE * Fix([YOUR_NUMERIC_FIELD / MOD_BASE)) ​ RESULT: [YOUR_NUMERIC_FIELD]-(MOD_BASE * Fix([YOUR_NUMERIC_FIELD / MOD_BASE)) ​
 </​file>  ​ </​file>  ​
-//e.g.// for splitting four parts to huge MS Access file we must use mod 4 \\+//e.g.// for splitting four parts to huge MS Access file we must use mod 4\\
-(After divided by 4, remainder must be 0, 1, 2, 3) \\+(After divided by 4, remainder must be 0, 1, 2, 3)\\
 <file excel sample.txt>  ​ <file excel sample.txt>  ​
 RESULT: [YOUR_NUMERIC_FIELD]-(4 * Fix([YOUR_NUMERIC_FIELD / 4))  RESULT: [YOUR_NUMERIC_FIELD]-(4 * Fix([YOUR_NUMERIC_FIELD / 4)) 
 </​file> ​ </​file> ​
-Then filter by result for each reminder (0, 1, 2, 3) value to get smaller pieces of database\\+Then filter by result for each reminder (0, 1, 2, 3) value to get smaller pieces of database\\
 You can download running sample from below link. \\ You can download running sample from below link. \\
 {{:​functions:​equivalent_of_mod_function_in_ms_access.zip|Download example file}} {{:​functions:​equivalent_of_mod_function_in_ms_access.zip|Download example file}}
 [<6>] [<6>]
 <​php>​esnek_yatay_reklam();</​php>​ <​php>​esnek_yatay_reklam();</​php>​