Cool, thanks!!!

Just thought about this, what if I wanted to add a field called OLD_SALES_AMOUNT which will be another select for the prior year sales?

The output fields will be LOCATION_NAME, SALES_AMOUNT,...

Stefan_G,

Thanks a bunch, your solution works. I did not not drop my tables though as they have production data.

By the way I am not a student, whish I could...

Hello Lowell,

Thanks for the prompt reply.

I forgot to mention that I have already tried the ISNULL function earlier and it still didn't work (as I was looking for the...