Retrieve different fields based on input?

[shukla]

use this code:
year1= year(delivery)
select case year1
case 1996:
'your code for year 1996

case 1997:
'your code for year 1997

case 1998:
'your code for year 1998

...
and so on