my query is ,
If suppose I have 2 tables:
A & B
A has Field Name ProjName with Value Prj-1
If I create a new Query and Add Table A and double click on Field ProjName it gets added and I save it with name Prj_Qry
so now Value Prj-1 from Field Name ProjName from Table A is saved into query Prj_Qry
B has Field Name Name
now I want to export that Value Prj-1 to Field Name Name , in Table B , How do I do that using a query?
I want to fetch value from A into Query and Export that Query Value to B.
How do I do this? I already fetched value from A as I said above, I just want to export to a FieldName in Table B.