Page 1 of 1
Calculating dates
Posted: Mon Feb 28, 2005 7:02 pm
by 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__
=> RE: Calculating dates
Posted: Tue Mar 01, 2005 9:30 am
by 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
==> RE: Calculating dates
Posted: Tue Mar 01, 2005 6:42 pm
by 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
===> RE: Calculating dates
Posted: Tue Mar 01, 2005 8:28 pm
by kfleming
Do you have records where the date field is blank?____Kathleen__R&R Support