LookUps

[japanik]

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, 2008 by Guest