SQL.REQUEST Returns Single Cell
 

I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn

SQL.REQUEST Returns Single Cell
 

You need to enter this as an array formula. Use ctrl + shift + enter

"Glenn1203" wrote:

I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn

SQL.REQUEST Returns Single Cell
 

Thanks James. So the sequence would be to enter the formula in a cell, but
instead of hitting enter, I should hit ctrl+shift+enter? I tried that, and
it didn't change the result. What could I be doing wrong? Thanks, Glenn

"James W." wrote:

You need to enter this as an array formula. Use ctrl + shift + enter

"Glenn1203" wrote:

I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn

SQL.REQUEST Returns Single Cell
 

You have to select as many cells (rows and columns) as you expect it to
return data if you are going to try ctrl+Shift+enter. You select the cells,
go to the formula bar and enter the formula, commit with Ctrl+Shift+Enter

--
Regards,
Tom Ogilvy

"Glenn1203" wrote in message
...
Thanks James. So the sequence would be to enter the formula in a cell,
but
instead of hitting enter, I should hit ctrl+shift+enter? I tried that,
and
it didn't change the result. What could I be doing wrong? Thanks, Glenn

"James W." wrote:

You need to enter this as an array formula. Use ctrl + shift + enter

"Glenn1203" wrote:

I enter a sql.request function in a worksheet cell, and it returns
only the
first column of the first matching row of the database. How can I
modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn

SQL.REQUEST Returns Single Cell
 

That was the ticket! Thanks for the help. Glenn

"Tom Ogilvy" wrote:

You have to select as many cells (rows and columns) as you expect it to
return data if you are going to try ctrl+Shift+enter. You select the cells,
go to the formula bar and enter the formula, commit with Ctrl+Shift+Enter

--
Regards,
Tom Ogilvy

"Glenn1203" wrote in message
...
Thanks James. So the sequence would be to enter the formula in a cell,
but
instead of hitting enter, I should hit ctrl+shift+enter? I tried that,
and
it didn't change the result. What could I be doing wrong? Thanks, Glenn

"James W." wrote:

You need to enter this as an array formula. Use ctrl + shift + enter

"Glenn1203" wrote:

I enter a sql.request function in a worksheet cell, and it returns
only the
first column of the first matching row of the database. How can I
modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn