create a Command object using a union statement.
If I followed your request you would something like
select field_1, field_2 , field_3, field_4, 'Depart' as mintype
from tablename
union
select field_1, field_2 , field_3, field_4, 'Pick' as mintype
from tablename
this gives you the table twice with an extra field called mintype where all of the rows from the first use of the table has the value 'Depart' and all of the rows form the second use of the tbale has the value 'Pick' (use whatever labels youwant here).
now you have two instances of every row in the tbale and you can use the mintype field to group on and/or to control how to make your time value formula (e.g. if mintype='depart' then this calculation else ...)
IP Logged
