<br>Hi Cody <br>As promised, here is an example of the problem that I am having regarding formula questions (7/13/2000 posting)<br><br>2 example databases involved. For simplicity sake I will use 1 call and minimal fields.<br><br>call_header database<br>call_number client_number opening_call_date<br> 001447 109 20000629<br><br>call_activities database<br>call_number activity_date <br> 001447 20000629 <br> 001447 20000630 <br> 001447 20000701<br> 001447 20000702<br> 001447 20000705<br> 001447 20000708<br><br>Databases are linked via the common call_number field. <br>In plain english, this is what I am trying to accomplish. <br><br> If a call has activities for the date range specified, give me all the activities for the call.<br><br> Using the above database and criteria, if my query asked for the activity_date range of 20000701 thru 20000708 the output woud include all the activities for all calls(within the range). So in the above example, I would get the complete thread even though I only asked for a specific date range of activities. This would give me a complete picture of all the call activities. In real life the databases would include maybe 50 calls. Out of those, 40 (or so) would have been open and closed within the activity date range specified. The other 10 could have activities going back to dates prior to the range specified. <br><br><br>What I am actually doing now is running a query that asks for the activity_dates <br><br>({Call_activities.Activity_Date} = {?date_range}) <br>//or ({Call_header.Call_Number} in ["000000" ]) <br><br>and if the the call originated before the specified date opening_call_date, <br>then I rerun the query asking for the date range or the call_header.call_number .<br><br>({Call_activities.Activity_Date} = {?date_range}) <br>or ({Call_header.Call_Number} in ["001447" ])<br><br>Sooo, what kind of formula would test each call and determine <br>a: what calls had activity within the date range specified<br>b: if there are prior activities to the date range specified, include the prior activities and do this in one pass of the database<br><br>Cody, I hope this makes the question clear. Thank you very much for your interest and your input.<br><br>Steve Koch (mayor)<br>Clovis Point Inc.<br>