I am using MS Access 2010 I have a pass thru query getting data from db2 no issues here, my problem is if the results are zero I want to show the month field (SHSHPM) = 4 and the year (SHSHPY) = 2014 and the COST field would equal zero amount. If I ran the pass thru I get nothing, which is correct. Does anyone know how I can do that? Thank you in advance.