Query

[Guest]

Hi,

I have a table with columns

Table 1 Columns:
Policy; Total Account Value; Bond; Stock; Money Market

Table 2 Columns:
FundAllocation;Bond; Stock; Money Market

I want to create Table 3:
Policy; Total Account Value; Bond; Stock; Money Market;FundAllocation

Fund Allocation is a certain %, there are 10 types of fund allocation with
the data = 1-10, so I just want to add the correct FundAllocation (#1-10) to
the table. And I know that the (Bond; Stock; Money Market columns) in table
2 are % that match with the corresponding (Bond; Stock; Money Market columns)

Thanks

 

[Jeff L]

I don't completely understand but I'll give it a shot. If Bond, Stock,
and Money Market match in both tables, you should be able to join those
fields together in a query to get your FundAllocation. You really
don't need a third table.