Add data from previous record if blank

[mbc321]

I have a table with "Date" and "Rate" fields. Not every record contains a value in the "Rate" field. is there a query that would insert the value from previous record in case the "Rate" field is null?
The sample table looks like this:

Date;Rate
20070101;100
20070102;
20070103;
20070104;200
20070105;205
20070106;206
20070107;


20070108;195

The result schould look like this:

Date;Rate
20070101;100
20070102;100
20070103;100
20070104;200
20070105;205
20070106;206
20070107;206
20070108;195

pls i need used Query
Thank you

[RuralGuy]

I don't think you can do it with a query but you can fill in the table if you walk through the RecordSet.