C
c8tz
Hi,
This is a query I have created that picks up the top 3 dates for this
data (for example) :
Tree Pos2 Date
1 15 23/08/2005
1 20 12/02/2006
1 32 15/10/2006
2 17 23/08/2005
2 18 12/02/2006
2 20 15/10/2006
The top 3 dates are 23/08/2005(date1) ; 12/02/2006(date2) ;
15/10/2006(date3)
Using this data with the dates, I need do a calculation such that it
counts the number of days between date2 and date1 and also date3 and
date2.
Using this : it must do another calculation : noof days/pos2
I've tried using a crosstab query but how do i use the column headings
of the date?
I tried writing a function and using queries but got lost halfway...
but it wasn't taking the pos2 data well - it needed it in a
calculation..
My programming skillz isn't there yet - please help!
Thanks heaps in advance!!
This is a query I have created that picks up the top 3 dates for this
data (for example) :
Tree Pos2 Date
1 15 23/08/2005
1 20 12/02/2006
1 32 15/10/2006
2 17 23/08/2005
2 18 12/02/2006
2 20 15/10/2006
The top 3 dates are 23/08/2005(date1) ; 12/02/2006(date2) ;
15/10/2006(date3)
Using this data with the dates, I need do a calculation such that it
counts the number of days between date2 and date1 and also date3 and
date2.
Using this : it must do another calculation : noof days/pos2
I've tried using a crosstab query but how do i use the column headings
of the date?
I tried writing a function and using queries but got lost halfway...
but it wasn't taking the pos2 data well - it needed it in a
calculation..
My programming skillz isn't there yet - please help!
Thanks heaps in advance!!