I have 4 tables of records, I then have a 5th table of records that these relate to, a summary record if you want to call it that.

In my 4 tables each record has a date.

What I want to do is have the summary record in the 5th table show thr highest record date taking into account the date in each 4 tables.

Table 1 01/01/2011

Table 2 10/02/2011

Table 3 02/01/2011

Table 4 05/01/2011

Table 5 would display the record from Table 2.

I know and have been using the Max function to get these into 4 seprate calculations in table 5. I just can't wokrout how I can get them into one field, this field showing the highest date from the related records.

I hope this is clear, seems a little hard to discribe.

Try:

Max (

Max ( Table 1::Date ) ;

Max ( Table 2::Date ) ;

Max ( Table 3::Date ) ;

Max ( Table 4::Date ) ;

)

Of course, this begs the question why not use a single table for all the data.

Thanks, that worked. Makes me feel like a dumb a*s...

Only a few fields in each table are the same. one table isn't an option.