Filling cells with previous row's data

[Guest]

I have a query that is pulling dates, times(down to seconds), and related
data from other queries. The data from each indivual query is not for every
second, but I would like to fill any empty boxes with the previous boxes
data. How can I do this?

For example:

08/05/2006 9:41:00 PM 59.998
08/05/2006 9:41:01 PM
08/05/2006 9:41:02 PM
08/05/2006 9:41:03 PM
08/05/2006 9:41:04 PM 59.996

I would like to fill 9:41:01-03 with 59.998. There are not always the same
number of empty rows. Please help!

Thanks.

 

[Joseph Meehan]

I have a query that is pulling dates, times(down to seconds), and
related data from other queries. The data from each indivual query
is not for every second, but I would like to fill any empty boxes
with the previous boxes data. How can I do this?

For example:

08/05/2006 9:41:00 PM 59.998
08/05/2006 9:41:01 PM
08/05/2006 9:41:02 PM
08/05/2006 9:41:03 PM
08/05/2006 9:41:04 PM 59.996

I would like to fill 9:41:01-03 with 59.998. There are not always
the same number of empty rows. Please help!

Thanks.

How is the data collected? Can you do this during collection?