Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
functions:equivalent_of_mod_function_in_ms_access [2017/02/07 16:35]
metecuma
functions:equivalent_of_mod_function_in_ms_access [2017/02/07 16:36]
metecuma
Line 16: Line 16:
 //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> ​ 
-  ​RESULT:​ [YOUR_NUMERIC_FIELD]-(4 * Fix([YOUR_NUMERIC_FIELD / 4)) +RESULT: [YOUR_NUMERIC_FIELD]-(4 * Fix([YOUR_NUMERIC_FIELD / 4))
 +</​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. \\