sql string in pivottable

[Kim Skytte]

I have created a data access page, that uses a pivottable to display some
information, that it looks up in table. However I want to sort the data in
the pivot table
according to some values entered by the user in the data access page.

I use the SQL string : SELECT * FROM [Tabel Members] in the pivottable
settings

But when the user selects weeknumber from a selectbox on the page, I what to
select
members from the table corresponding to that week. I have tried the
statement.

SELECT * FROM [Table Member] WHERE Weeknr=SelectBox1.Value

This does not work.

So!, how do I use control values on the correspoding data access page, for
use with a SLQ string in my pivottable.!


Sincerely Kim Skytte