S
Stephen Green
Following the instructions in MS Knowledgebase article #244968, I created a
page that include "All Values" in the drop down filter, and it worked (using
the Northwind database).
In my database however, I need to use a custom query - adding DISTINCT to
prevent duplicates and WHERE [field] > ' ' to prevent blanks.
Adding All Values to this scenario causes the All Values filter to run
automatically as the page is called. The remaining choices in the drop down
work fine.
Can I change this?
Also, in the same query I have entries with similar content:
Member
Guest Member
Founding Member
Choosing Guest Member or Founding Member works fine. But the Member filter
brings up all records that contain "Member", a list of all three of the
above criteria. Aside for changing those names, is there anything I can do
to get just "Members" in the query?
Thanks
Stephen
page that include "All Values" in the drop down filter, and it worked (using
the Northwind database).
In my database however, I need to use a custom query - adding DISTINCT to
prevent duplicates and WHERE [field] > ' ' to prevent blanks.
Adding All Values to this scenario causes the All Values filter to run
automatically as the page is called. The remaining choices in the drop down
work fine.
Can I change this?
Also, in the same query I have entries with similar content:
Member
Guest Member
Founding Member
Choosing Guest Member or Founding Member works fine. But the Member filter
brings up all records that contain "Member", a list of all three of the
above criteria. Aside for changing those names, is there anything I can do
to get just "Members" in the query?
Thanks
Stephen