viewing related records with a certain criteria

[stac_1]

Hi

I first wanted to thank everyone here in this forum for the help. This forum is the best idea since sliced bread and I have benefited tremendously - Thank you.

Now, I am trying create an automated report for work in progress. I have a relationship between cost db and a timeslip db. I need to retrieve the cost from the timeslip db for a certain customer for a certain period (ie: from the opening of the job 1/15/01 until 1/31/01) even though there are timeslip entries after 1/31, I only need the cost up to 1/31. Here is the kicker.... I need this to happen on multiple records and I need it to be automated as much as possible.

I know this is just within reach, but I can't figure out the best way to do this..... help!

Thanks ;-)