Autofilter

[tonijel]

Hi,
I have DAP which is generated on behalf of a query.
When I designed DAP, I placed field names in the Caption section & removed default navigation toolbar so I could have table-like view of that data in the browser.
I also use on one field group flter option.

**Is it possible to somehow use group filter option on more than one field in one DAP, but in that way so when choosing values from that fields I don't have to select values from all group filter fields to get the output?**

I would like to have control on that DAP like Autofilter option in Excel, and by aplying group filter on more more that one fileld I can't get the same functioality like in Excel when using Autofilter.

Is it possible to implement that kind of functionality at all in DAP?

 

[TTime]

DAP = Database Application? If using Access 2000 there is an option to export to Excel under the Tools option from the main toolbar. Could you export to Excel then interogate your data there? HTH Bernard

 

[tonijel]

Well TTime,
I would like to have Excel autofilter capabilities in my Data Access Page and not to use export from access to excel so users who are using DAP could have the same filtering capabilities like in Excel....
Is there some way to do implement this kind of filtering in DAP?

 

[TTime]

Unfortunately the only way I know of (but there maybe others) is to use Queries with criterias that will filter tables or other queries. Sorry I can't sugest the Excel equivalent. Other than to create a tool linked to your querie and attach it to the main toolbar? Bernard

 

[tonijel]

Thx Ttime,
i was guessing I could do that using parameter querys.
I think this is not the only way to do it but obviously it is not that easy to do it