Update Record With Info From Another Table.

[Riru]

Thanks for any help.

I have a database which tracks product batches test results and then any reported issues.

I have one table tblOne with [Batch Number] and [Release Time/Date].
The 2nd Table tblTwo [Problem/Issue] at [Time/Date].

What i need to do is get the last batch number from table one which would have been released.

Example:

Batch: 275 Released: 21/09/2012 06:15
Batch: 453 Released: 30/09/2012 07:20

Problem: Wrong Batch Time/Date: 21/09/2012 08:20 Batch:????

How would i update table with correct batch in tblTwo

 

[CJ_London]

to do an update, you must have something that can relate one table to the other. So far as I can see there is nothing comparable between the two tables - so can you include the expected end result you require and also explain to logic for arriving at the end result.

It is also not clear which table you want to update

 

[CazB]

would you want the answer to be batch 275?

 

[Riru]

Hi yes CazB.

To explain further:

Table 1 (tblOne) has Fields [Batch Number] and [Release Time/Date]

Table 2 (tblTwo) has fields [Problem/Issue], [Time/Date], [Batch Number]

I want a macro to search tblOne to find the [Batch number] which occurs before [Time/Date] in tblTwo.