J
Jack Stenhouse
I need to be able to filter a list where the column headings change.
e.g. Junior Middle Senior Staff Calendar All
These cannot be static as each school has different names.
They key these names in a "Parameters" sheet and I show the names in the columns in the database (and the selection criteria).
(Select1, Select2, Select3, Select4, Select5, Select6) These are also shown beside Radio Buttons to allow them to select which one they want (Select3 = Senior).
The Criteria then looks like this . . .
Junior Middle Senior Staff Calendar All Date
E >0 (changes with radio button)
E >0
I think this should filter the database where "Senior" = "E"
OR "All" = "E"
It only filters the records where "All" = "E"
Does anyone have any clues as to how I can resolve this?
Thanks for your interest. I appreciate any help you can give.
e.g. Junior Middle Senior Staff Calendar All
These cannot be static as each school has different names.
They key these names in a "Parameters" sheet and I show the names in the columns in the database (and the selection criteria).
(Select1, Select2, Select3, Select4, Select5, Select6) These are also shown beside Radio Buttons to allow them to select which one they want (Select3 = Senior).
The Criteria then looks like this . . .
Junior Middle Senior Staff Calendar All Date
E >0 (changes with radio button)
E >0
I think this should filter the database where "Senior" = "E"
OR "All" = "E"
It only filters the records where "All" = "E"
Does anyone have any clues as to how I can resolve this?
Thanks for your interest. I appreciate any help you can give.