Hi guys;

Strange one:
I have an excel spreadsheet linked back to a query in my Access DB for displaying a progress bar chart. Worked perfectly except that I wanted null values in the query to appear as zero in the Excel sheet. I inserted the nz() expression into the Access query for the fields that were returning null, ran the query and they now show zero as the value. Perfect!

Problem is that when I went back to the Excel spreadsheet, the query is no longer showing as available for use. To test I went back to the Access query and restored it to the original version which returned the null values, checked the Excel sheet and sure enough the query is again available. I thought that maybe it was because the query had an expression in the feilds I wanted to show as zero so I created a query based on the original query and it still doesn't show up as available in the Excel sheet.

Any ideas?

Thanks everyone!!!