SQL parameter query - more than cell value
 

I have created a parameter query in Excel which returns data from an sql
database. The parameter is based on a cell value. Rather than return records
equal to the cell value, I would like to return those which are greater than
the cell value. I have tried everything I can think of but no luck so far.
Any ideas please?

Thanks
Sarah

SQL parameter query - more than cell value
 

Sarah

Just add the operator to your parameter query in MSQuery

[TheValueINeed]

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"SarahS" wrote in message
...
I have created a parameter query in Excel which returns data from an sql
database. The parameter is based on a cell value. Rather than return
records
equal to the cell value, I would like to return those which are greater
than
the cell value. I have tried everything I can think of but no luck so far.
Any ideas please?

Thanks
Sarah