Using append/update queries to transfer record data from one Table to another Table

[DiDi]

To All: I desperately need helps on the following :

I am trying to combine records from a make table query result (Table A)
shown in the example below:


Id# plant# batch# season_ID Fertilizer

140 12 A 1 fert1
140 12 A 2 fert2
140 12 A 3 fert3
140 12 A 4 fert4

into a table (Table B) has a format in the following:

(For season_ID=1, fertilizer is a Main_fert, for season_ID=2,or,3, or
4,
fertilizer is the support_fert)

Id# plant# batch# MAIN_fert Support_Fert1 Support_Fert2
Support_Fert3
140 12 A fert1 fert2 fert3 fert4

---------------------------

So each time, Table A has only one unique ID#, in other words, the
records can be as only one record to a maximun of 4 records, I would
like to transfer

Table A records into Table B each time when a new Table A created.

How do I do that? I thought about open data source of Table A and loop
through the Table A record to check the number of records, then for the
first record

using appened qury and append to Table B, later if more record founds
using an update query to update the information, I need help to show me
example how to

start doing it. I truely appreciate.

 

[Rick B]

You have posted this four times. Please stop.

Someone will get you an answer. Multiple posts will not get you a faster
response.