King_kamikaze
Registered User.
- Local time
- Today, 17:05
- Joined
- Jan 13, 2005
- Messages
- 48
Hello everyone,
I have got an update query that i use to update a main table. The query uses two tables, "StartingPoint" & "UpdateFuture". "Reference" is the primary key in StartingPoint and is also in UpdateFuture table but not as a primary key because there can be multiple instances of the Reference.
Every record in UpdateFuture has a date that it was imported into the table, if the UpdateFuture table has two instances of the same reference i would like the query to only update StartingPoint with the most recent one according to the DateImported field.
Any help on this would be greatly appreciated and i am sorry if you cant quite understand what i am looking to achieve, please ask if you need me to clarify anything.
Many thanks
Tim
I have got an update query that i use to update a main table. The query uses two tables, "StartingPoint" & "UpdateFuture". "Reference" is the primary key in StartingPoint and is also in UpdateFuture table but not as a primary key because there can be multiple instances of the Reference.
Every record in UpdateFuture has a date that it was imported into the table, if the UpdateFuture table has two instances of the same reference i would like the query to only update StartingPoint with the most recent one according to the DateImported field.
Any help on this would be greatly appreciated and i am sorry if you cant quite understand what i am looking to achieve, please ask if you need me to clarify anything.
Many thanks
Tim