Microsoft Query

**Colin Smitie** · 05-08-2017, 11:52 PM

Good Day...

I have created a Microsoft Query. It is looking at a SQL Table with several columns in it. The only two columns I use is the StockCode and UserField4. The StockCode is used as the criteria field.

0.JPG

1.JPG

The Parameter is set to look at the value entered into cell A2 and, the query returns the value in the UserField4 column.

3.JPG

4.JPG

On below picture it can be seen that the value is returned as well as the column heading.
5.JPG
Is it possible to only return the value and not the table heading called "UserField4" as well?

**dflak** · 05-09-2017, 03:26 PM

I don't think so. You are stuck with the column header. You could always hide the row or do the query on another page and then use something like B2='Hidden Query Sheet'!B2.

**Colin Smitie** · 05-10-2017, 01:25 AM

Originally Posted by dflak

I don't think so. You are stuck with the column header. You could always hide the row or do the query on another page and then use something like B2='Hidden Query Sheet'!B2.

Thank you for the feedback. I will continue to research but, at this stage it does not seem possible. Your suggestion could however be a workaround. Will test it.