2) it goes into a table query called ALLMAINTENANCE
There is no such thing as a "Table Query". They are two different objects. No data physically resides in queries. As I said before queries are really just "filters" or "criteria".
ALL Data (and I emphasize the word "ALL"), is stored at the table level.
So the new data is NOT going into a "query". It is going into a Table, and the query is just retrieving the data from the table.
PS - the sql of ALLMAINTENANCE displays this -
SELECT *
FROM MAINT;
So this is telling you all the the query ("filter") is doing. The "*" means all fields. So, it is telling the query to return all records from the MAINT table. The MAINT table is actually where the data resides.
Since that query does not have any Criteria on it, it is returning ALL the records from your MAINT table. So if you open the MAINT table and compare it to your ALLMAINTENANCE query, they should look exactly the same (have the same number of records and fields).
If you want to copy the records over from "TABLE1" to the MAINT table (the table that your ALLMAINTENANCE query pulls from), you could do so with an "Append Query".
Here is information on how to do that:
Add records to a table by using an append query
Note that if both tables have a "Autonumber" ID field, you do NOT want to try to copy that over from TABLE1 to the MAINT table, as you cannot map values into an Autonumber field. Access will automatically populate it when you add a new record.
I am trying to transfer a selected row from a table to the next empty row of a query in MS ACCESS.
Another thing to understand, Access is very different than Excel. You can sort your records by any field you want in Access, but the records themselves do not have any "natural" order. Something explain Access tables like this - think of them as a "bag of marbles", all jumbled up. So there is no "set" order to them, or no "new next line". When you want a new record added, think of it as just dropping a new marble into a bag of existing marbles. There is no problem with adding new ones, but there is no pre-determined space (like a blank row) that it goes into.
I am not sure if you are talking over a database from someone else, but here is a word of caution from someone who has been there - Access is MUCH different than Excel, and not nearly as intuitive as Excel. Before you really start messing around with existing databases, or creating your own, I HIGHLY recommend that you educate yourself on two things:
1. Learning how to use Access (via a book, course, on line education, etc) - trust me, this really isn't something you can "figure out" as you muddle through it;
2. Learning about Relational Databases and Database Theory (especially on the Rules of Normalization)
I tried creating my first database when I did the first thing, but not the second (I understood Access, but now how to build a well-designed database). I spent month of frustration spinning my wheels, until somebody told me to read up on Relational Database Design. I had to scrap most of 6 months of work, but once I did it the right way, things worked correctly and smoothly (they still use that database, almost 20 years later). A poorly designed database will make even simple tasks difficult.
There are lots of good articles out there on this (just Google words like "Access database design and normalization").
Here is one to get you started:
Relational Database Normalization Basics | Database Solutions for Microsoft Access | databasedev.co.uk
