hrdpgajjar
Registered User.
- Local time
- Today, 19:08
- Joined
- Sep 24, 2019
- Messages
- 51
Hi all,
I have created a table with the details below,
Table Name : TPA Data
Column 1 : Registration No
column 2 : Regi. date
column 3 : details sent date
now table-2 details are,
Table Name : Client Details
Column 1 : Registration No (it will be same as TPA data table)
Column 2 : details sent date
Now i need to append "details sent date" field from "Clients Details" table to "details sent date" of "TPA Data" Table.
I've tried doing append query but not succeeded. I am totally new to to append query. Can any one guide me how can I append data from one table to another ?
Note : I need to append only data of same registration no, other data will remail intact.
Thanks
I have created a table with the details below,
Table Name : TPA Data
Column 1 : Registration No
column 2 : Regi. date
column 3 : details sent date
now table-2 details are,
Table Name : Client Details
Column 1 : Registration No (it will be same as TPA data table)
Column 2 : details sent date
Now i need to append "details sent date" field from "Clients Details" table to "details sent date" of "TPA Data" Table.
I've tried doing append query but not succeeded. I am totally new to to append query. Can any one guide me how can I append data from one table to another ?
Note : I need to append only data of same registration no, other data will remail intact.
Thanks