In the attached MS Access zipped file are two queries that are making a new table from the larger table.
First I am only at the query stage. How do I use the make table query in MS Access 2016. It is not as clear as it is in MS access 2010?
The second question is why does the output look like it does? The number are no longer in the order the larger table had them in, but
they seem to be jumbled again.
When this was imported from an Excel spreadsheet, I had to put in an index in the first column that I used on the table once it was imported
into MS Access to order the table values from 1 to ....
That worked as a post import trick to get the rows reorder again, but now they are back in the original jumbled form after I break the main table down into smaller tables.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed