urgent help needed... i have database with 10 tables. i want to fully join 4 tables which has 2 column present in all and join on the condition ofbthe 2 identical columns
urgent help needed... i have database with 10 tables. i want to fully join 4 tables which has 2 column present in all and join on the condition ofbthe 2 identical columns
this happens to me all the the time.
Write out the table and field name.
Example.
Id1: [Tbl_clients].[id]
Id2: [Tbl_tasks].[id]
by including the table/query the field is comming from it will tell access which one you intended.
Hope that helps