query parameters - EXCEL 2010

[clayp56]

I have a workbook that contains two sheets with two seperate queries. On the first sheet I have two cells desiginated to accept the values for the parameters. The first sheet accpets the values and populates the table correctly. The second sheet doesn't seem to accept the values and just returns blank rows.

Need help on this one.

Thanks

 

[clayp56]

Sorry, I gave you the one that didn't have the question marks in it. I found out that it must be the query because I put the query from sheet1 into sheet2 and used the parameter cells from sheet1 and it works. So I need to look at the first query I sent you and see why it is not working.