PC Review


Reply
Thread Tools Rate Thread

Dba query filter taken from Excel

 
 
Carmen
Guest
Posts: n/a
 
      24th Jan 2008
Hello,

Let's say I have the following queries in dba:
qry1
qry2
qry3
qry4....

qry1 is where the user put in the filters and qry 4 is the output that Excel
reads through pivot tables.

Since we may have many users and they may not be familiar with dba, I want
to have the filters done through excel, then this is passed on to query 1 and
then the pivots automatically refresh to obtain qry 4.

Is this possible?

For the filtering part in Excel, I'm thinking showing a pivot table with
header fields only where user can see all the available selections. Then on
the side, user can select to select the following <=, >=, =, between, in
list....

Any help would be appreciated.

Thanks,
Carmen

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF in Excel 2007 for Filter or Query likwidmack Microsoft Excel Programming 2 20th Jan 2009 03:30 PM
Excel auto filter doesn't recoginize case - won't filter AA from A =?Utf-8?B?TWlrZXk=?= Microsoft Excel Misc 1 29th Sep 2005 08:18 PM
Filter and query saved after filter by form =?Utf-8?B?dWJ1?= Microsoft Access Queries 4 24th Oct 2004 09:59 PM
Excel Filter/Query proben930 Microsoft Excel Misc 2 23rd Sep 2004 10:11 PM
Excel Function Query - How to filter with three criterias idlan Microsoft Excel Misc 1 5th May 2004 10:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:01 AM.