I'm trying to get an MS Access query (in Access 2002) to fill in the values of a previous record as long as the current record is null


For example, if I have the following table:

XNUMBER NAME
4 John
Mary
Michelle
Mark
David
Sharon
9 Rita
Noel
Christina
Esther
3 Andrew
Lisa
Peter
Rebecca
Gary...