BeckTowery Posted May 8, 2008 Share Posted May 8, 2008 Hi All! I'm hoping someone can shed some light on this situation I've got myself into. I've got three tables: One table of Accident event dates with an ID number(Key Field). One record for each event. The other two tables have the same structure but are Suspensions and Reinstatements. For every record in the first table I need to determine if it's event date is greater than ANY related Suspensions and LESS than any related Reinstatements. I've got this on one layout with two portals to the other tables sorted and related with the ID number and a calculation that works fine, but it only evaluates the FIRST row of each portal. I need the calculation to evaluate every line in each portal. Some IDs have one related Suspension and some have 10. Same with Reinstatements. Maybe I'm going about it the wrong way... Any help would me much appreciated! Beck Quote Link to comment Share on other sites More sharing options...
Techphan Posted May 8, 2008 Share Posted May 8, 2008 How are your 2nd and 3rd tables related to the ACCIDENT table? Quote Link to comment Share on other sites More sharing options...
BeckTowery Posted May 8, 2008 Author Share Posted May 8, 2008 The ID number is the key field for all the tables Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.