Recent content by Garbensor

Table 1 generates an autonumber ID that I need so I can put the data in Table 2. Table 1 groups data. So: 1. John. 100. Alaska 1. John. 200. Alaska 2. Charles.300. Texas Table 2 asigns the unique number 5. 1. John. 100. Alaska 6. 1. John. 200. Alaska 7. 2. Charles...

Normally the data is introduced in Access through a form that does double entry bookkeeping. This data goes to Table 1 and Table 2. I want to upload the data in batches so that we don't have to spend hours entering it manually. Table 1 generates an autonumber ID (allows duplicates) for 1 or...

1. Some data that will be inputted in table 1 shouldn't be in table 2. Its only specific data that needs a user to decide based on non access parameters. 2. Table 1 generates an auto number for the row. After that I can move the row toTable 2. As table 2 needs that auto number, then it will...

I see, but I can't use that suggestion Once table 1 is updated with the info from excel, I just need to move it to table 2, but I dont know how to do move only the rows from the excel, as table 2 has to take in duplicates. So if I append table 1 to table 2, it will add 14k rows :/ Thats why I...

Hello, I'm beginning to learn Access and I can't seem to find the answer so I think I'm approaching this in a wrong way. I have an Excel linked table(excel table) with 4 columns. Name, Address, Amount, ID From this table I run an apend query to an access table (Table1) with the same columns...