Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Report and a Form Filter

Experts, I have a report that uses a filter form:  "frmFilter_ShortByMonth"
I have a unbound combo:  "frmFilter_ShortByMonth.cboExecutiveOwner with a query as a row source:  
SELECT Import_Excel.ExecutiveOwner FROM Import_Excel GROUP BY Import_Excel.ExecutiveOwner;
The user selects a name from the cboExecutiveOwner then clicks the button and the report shows data for that selection.  

I now need to add functionality to show only records where the [ExecutiveOwner] is not null or "".
The user has to be able to do this has to be on the fly.  I know I can put the criteria within the query but I need it to be more dynamic.  

SELECT Import_Excel.*
FROM Import_Excel
WHERE (((Import_Excel.[Due Date per docs])>=[forms]![frmFilter_ShortByMonth]![txtDateFrom] And (Import_Excel.[Due Date per docs])<[forms]![frmFilter_ShortByMonth]![txtDateTo]+1) AND ((Import_Excel.Completed) Is Null) AND ((Import_Excel.ExecutiveOwner) Is Not Null And (Import_Excel.ExecutiveOwner)<>""));
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

oh yes, the check mark.   I forgot about that option.   Thank you once again...
You are welcome!

/gustav