Dump your data into a new table that has an AutoNumber field (ID) in
it. Now make a query that queries your address data and in another
column type ID MOD 3. In the criteria of that column, put =1. This
should give you records 1,4,7,10,13, etc.
Hope that helps!
Re: VBA Creating Table in Second MDB returning curious error ...Exporting them from a query to ... a table - they still retain their property of being an AutoNumber field.... > Look at the query that is causing the problem. ... > Check the Queries and Table in the source query to ensure ... (microsoft.public.access.modulesdaovba)
Re: Cross Tab Query ... Is this how i would add an AutoNumber Field to my queries?... and save it with name "qryPosition"... then make the Cross Tab Query... (microsoft.public.access.queries)
Re: VBA Creating Table in Second MDB returning curious error ...Exporting them from a query to ... >a table - they still retain their property of being an AutoNumber field.... >> Look at the query that is causing the problem. ... >> Check the Queries and Table in the source query to ensure ... (microsoft.public.access.modulesdaovba)
VBA Creating Table in Second MDB returning curious error ... Look at the query that is causing the problem. ... Check the fields that you have selected for exporting to ... Check the Queries and Table in the source query to ensure ... that only one, or no, Autonumber field is exported. ... (microsoft.public.access.modulesdaovba)
VBA Creating Table in Second MDB returning curious error ... acTable, NameOfQuery, NameOfTable, False, False ... I find this curious since I'm not creating or including an Autonumber field.... The Select query itself is a combination of two other queries and a table. ... (microsoft.public.access.modulesdaovba)
