V
vmadan16
Dear All,
I have another doubt in Access. Can you help in that also. I have explained
it below.
There are 3 tables
1. Account - (Fields - Account name, Accountid, Address, etc)
2. Account Misc - (Fields - Accountid, cpnum, Cluster, etc..)
3. CC - (contains only Account name field)
Both the tables have one same field Accountid. Joined 2 tables usig that
Accountid field. to retrive the Cpnum and cluster from Account Misc through
Account name field in Account table.
I want the cpnum and cluster field alone to be filled in the CC table.
The CC table does not have the exact match of the Account table for example
CC table have Microsoft corporation but in the account table only Microsoft
will be there. another example ASAP S.A Ltd in CC table it will be ASAP in
Account table.
One more thing the CC table may have data which the Account table does not
have so in that cases there should be a blank space in the CC table to
respective areas.
Pls help me out with this macro.
I have another doubt in Access. Can you help in that also. I have explained
it below.
There are 3 tables
1. Account - (Fields - Account name, Accountid, Address, etc)
2. Account Misc - (Fields - Accountid, cpnum, Cluster, etc..)
3. CC - (contains only Account name field)
Both the tables have one same field Accountid. Joined 2 tables usig that
Accountid field. to retrive the Cpnum and cluster from Account Misc through
Account name field in Account table.
I want the cpnum and cluster field alone to be filled in the CC table.
The CC table does not have the exact match of the Account table for example
CC table have Microsoft corporation but in the account table only Microsoft
will be there. another example ASAP S.A Ltd in CC table it will be ASAP in
Account table.
One more thing the CC table may have data which the Account table does not
have so in that cases there should be a blank space in the CC table to
respective areas.
Pls help me out with this macro.