Thanks alot for the reply Jeff.

this query worked really well. But i still have the zeros in amount field for the below records.

DateAreaAmountAOD

2008-02-01 BA 0 2008-03-01

2008-02-01 BA 0 2008-04-01

2008-03-01 BA 0 2008-04-01

These needs to be filled with previous month's amounts.

with below records respectively

2008-02-01 BA 50 2008-02-01

2008-02-01 BA 50 2008-03-01

2008-03-01 BA 30 2008-03-01

Thanks alot for the help.

Neela