Query Help

[ChrisDo11]

i currently have 2 tables.

Table 1

File Number, Section Name, Date

Table 2

File Number, Section Name


I want to add the date from Table 1 into a field (also called Date) in table 2. The tricky part is that each File Number has many Section names and i need the date from Table 1 to find the right File number, then the right section name in table 2. I don't use Access much but i'm assuming a query will do this? I have tried a query, but i get duplicate records. Is there a way to get the records to merge/update instead of creating the second record?

Thanks,

 

[Vassago]

Create an update query with both tables.

Join File Number and Section Date between the two tables in a one to one relationship in the query.

For Field, choose Date from table2(where you want the date to go)

For Update To, choose [table1].[Date]

Now when you run this query, the database will look for the any records that look the same in table2 and table1 and paste the coinciding dates to the date field.

Hope that helps.

Vassago