insert query

[cahickm2]

I need help with a query that inserts a date from above into blank cells in the same cloumn.

ex.
Date,Time
23/07/07, 00:00
blank
blank
blank
blank
blank
23/07/07, 01:00
blank
blank
blank
blank
blank

and so on.

The data I am working with covers and entire week (168 hours) and it is time consuming to copy and paste. Can someone help me please?

 

[giacomo]

this query assumes that you have a autonumber field (ID in my example)

UPDATE tblA SET tblA.Field1 = DMax("field1","tblA","tblA.ID <= " & [tbla].[id])
WHERE (((tblA.Field1) Is Null))
order by ID;

replace tblA with your table name, and field1 with your field name