K
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
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