May 29, 200817 yr Newbies Dear all. I hope I can get some help here... I have two databases, they are related. In the first one: 3 fields per record (start date, end date, value). These records define a certain value for a certain period. In the second database: 2 fields (month date, value) What I like to achieve is to input a month (date) in the second database, and then the value should be looked up in the first database: > if date in the second database is in the range (period) of a record of the first database, take the related value of that record. Of course I managed to look up for the value, but only of the first record of the first database. Any help would be highly appreciated. Thanks for reading! I found the solution. It was just a entering mistake of values in the second database. Sometimes you really don't see the simple things anymore ... Edited May 30, 200817 yr by Guest
Create an account or sign in to comment