Hello guys,
I have an issue which I assume is very simple yet I can't seem to figure it out. (Just started learning Access a few weeks ago)
I have a table called Table1 with the following columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID (autogenerated)[/TD]
[TD]SUB[/TD]
[TD]Month[/TD]
[TD]Total[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]GOP[/TD]
[TD]1901[/TD]
[TD]500[/TD]
[TD]Payment[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]GAP[/TD]
[TD]1901[/TD]
[TD]600[/TD]
[TD]Payment[/TD]
[/TR]
</tbody>[/TABLE]
And the second Table2 with the following columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AutoNumber(Autogenerated)[/TD]
[TD]ID[/TD]
[TD]CustomerID[/TD]
[TD]Amount[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So what I want is to append the data from Table 1 to Table 2 but only specific columns :
ID---> ID
Total---> Amount
and the rest to be inputted by the user, so:
CustomerID---> Inputted by user
Name---> Inputted by user
The kick is that there will be many rows to be appended but the CustomerID and Name should be the same input for all rows.
So the end result would look like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AutoNumber(Autogenerated)[/TD]
[TD]ID[/TD]
[TD]CustomerID[/TD]
[TD]Amount[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]123456[/TD]
[TD]500[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]123456[/TD]
[TD]600[/TD]
[TD]John[/TD]
[/TR]
</tbody>[/TABLE]
And this process is to be repeated every month, so ideally there would be a way to only append for the selected month e.g. 1901. Or is there a way to append everything but ignore duplicates which would be easier maybe?
Thanks a lot!
I have an issue which I assume is very simple yet I can't seem to figure it out. (Just started learning Access a few weeks ago)
I have a table called Table1 with the following columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID (autogenerated)[/TD]
[TD]SUB[/TD]
[TD]Month[/TD]
[TD]Total[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]GOP[/TD]
[TD]1901[/TD]
[TD]500[/TD]
[TD]Payment[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]GAP[/TD]
[TD]1901[/TD]
[TD]600[/TD]
[TD]Payment[/TD]
[/TR]
</tbody>[/TABLE]
And the second Table2 with the following columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AutoNumber(Autogenerated)[/TD]
[TD]ID[/TD]
[TD]CustomerID[/TD]
[TD]Amount[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So what I want is to append the data from Table 1 to Table 2 but only specific columns :
ID---> ID
Total---> Amount
and the rest to be inputted by the user, so:
CustomerID---> Inputted by user
Name---> Inputted by user
The kick is that there will be many rows to be appended but the CustomerID and Name should be the same input for all rows.
So the end result would look like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AutoNumber(Autogenerated)[/TD]
[TD]ID[/TD]
[TD]CustomerID[/TD]
[TD]Amount[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]123456[/TD]
[TD]500[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]123456[/TD]
[TD]600[/TD]
[TD]John[/TD]
[/TR]
</tbody>[/TABLE]
And this process is to be repeated every month, so ideally there would be a way to only append for the selected month e.g. 1901. Or is there a way to append everything but ignore duplicates which would be easier maybe?
Thanks a lot!
Last edited: