Calculating dates

[FRED_EMMERICH_(Guest)]

I have a master table linked to a detail table, which contains date-oriented records. How would I calculate the difference between the earliest detail record, and the latest one, for a given master record?____thanks__Fred__

[kfleming]

You would need to create two totals that take the min and the max of the date and then place them on a detail footer band.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I tried that but only the MIN() worked, it gave me a date. The MAX() gave me a zero.____I am using SQL 8.1

[kfleming]

Do you have records where the date field is blank?____Kathleen__R&R Support