Search results

Re: VBA code/ selecting every 3th record Thanks, but SELECT * FROM Employees WHERE [ID] Mod 3 = 0; works when ID is autonumber for example. What i need is select this every 3th record from "table(Employees)" and insert into "table (EmployeesCopy) using Access module. thanks a lot

good evening i´ve problem with creating module in access. I want to select every 3th row from "mytable" and create backup/copy of "mytable" and put into it this records. I only have this query SELECT * FROM mytable WHERE [TheColumn] Mod 3 = 0; thank you for any advice