Query From Newest Date

[SSgtJ]

In a nutshell I am trying to update fields in table 2 with information in table1 from a date specified in table 1
I am attaching 2 screen shots of the tables. I had to hide alot of fields due to the type of info (sorry) but you will get the gist.
Table 1 shows Each machines information as it stands currently. So Asset number is a unique house number (like a serial for our own records) and location is of course where it is and serial number is self explanatory as well.
this table is imported daily from a corporate database that I cannot change or alter in any way. This Corporate database gets updated with info we tell them. So our system (table 2) should reflect the changes made. This is not always the case.
Table 2 (the 2 fields are asset location and the business day) houses the daily financial records by Asset#. So as you can see I just copied a few in this table for the visual. So location 010101 has so far this month 19 records. Now if you notice on the 5th the asset number changed. But if you look at table 1 location 010101 has a start date (start date is the start of a new asset) of 01/03/2010. So table 2's info should reflect that. Example 3 illustrates that.


I need table 2's Asset field to show table 1's asset field from the start date in table 1. I feel like I am just rambling here and not making any sense. I hope the info I have given is somewhat decipherable. Due to the nature of the info it is hard to send the actual tables. I apologize again.

[SSgtJ]

I apologize but I have figured out my own question. I was looking at it way too hard. I am fairly new so please forgive me. I just needed a greater than or equal to added in my statement.

[RuralGuy]

It is better if you are able to solve your own problem anyway. You learn a lot more that way and post back with your solution teaches others. How about following the link in my sig and marking this thread as Solved?