troubleshooting Question
MS ACCESS: Filter query based on check box selection within userform..
Dale James asked on
Hello Team
Can you please advise on the syntax that would be required to filter a query from selecting a true or false value of a checkbox.
Form Name: frmAnalytics
Query Name; qryRenewal
Checbox Name. chkNoErrors
Reference Field: TotalErrorCount
The checkbox purpose is to allow the user to select whether or not the qryRenewals is to be filtered with records that show all records (false checkbox value) or to only show records that have a positive Total Error Count value which means excluding any Null or 0 entries in the Total Error Count field.(true checkbox value)
In the qryRenewals I already have criteria filters that are driven by the selections of the frmAnaIytics form and would like to add the checkbox filtering using the same method. For example, I have a filter field in the query which filters by which team is selected from a drop down control on the form using:
IIF([Forms]![frmAnalytics]
The field holding the above formula has a '<>False' query criteria applied.
As always, any assistance is much appreciated.
Sincerely
Dale
I have form which is used to filter various queries and export for reporting.
The form allows the user to select via a drop down control a specific query to filter, for example qryRenewal.
What I would like to do is, allow the user the have the option to select a checkbox to filter out records that contain any null or 0 entries in the TotalCount field of the qryRenewal.
I already have criteria filters sent into the qryRenewal that are linked and determined by the selection of the frmAnalytics for dates, query selection, team selection etc.
On this form, the user has the option to select dates for data pull, type of query to pull from and if they wish to filter only by particular team members or managers etc.
In my queries I have input into the following in order to pull filter by a selected user:
What I would like to do is to add another filtering field that refers to
I
Can you please advise on the syntax that would be required to filter a query from selecting a true or false value of a checkbox.
Form Name: frmAnalytics
Query Name; qryRenewal
Checbox Name. chkNoErrors
Reference Field: TotalErrorCount
The checkbox purpose is to allow the user to select whether or not the qryRenewals is to be filtered with records that show all records (false checkbox value) or to only show records that have a positive Total Error Count value which means excluding any Null or 0 entries in the Total Error Count field.(true checkbox value)
In the qryRenewals I already have criteria filters that are driven by the selections of the frmAnaIytics form and would like to add the checkbox filtering using the same method. For example, I have a filter field in the query which filters by which team is selected from a drop down control on the form using:
IIF([Forms]![frmAnalytics]
The field holding the above formula has a '<>False' query criteria applied.
As always, any assistance is much appreciated.
Sincerely
Dale
I have form which is used to filter various queries and export for reporting.
The form allows the user to select via a drop down control a specific query to filter, for example qryRenewal.
What I would like to do is, allow the user the have the option to select a checkbox to filter out records that contain any null or 0 entries in the TotalCount field of the qryRenewal.
I already have criteria filters sent into the qryRenewal that are linked and determined by the selection of the frmAnalytics for dates, query selection, team selection etc.
On this form, the user has the option to select dates for data pull, type of query to pull from and if they wish to filter only by particular team members or managers etc.
In my queries I have input into the following in order to pull filter by a selected user:
IIF([Forms]![frmAnalytics]![cboUser]<>"",[User]=[Forms]![frmAnalytics]![cboUser],True)
What I would like to do is to add another filtering field that refers to
I
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Fellow title is reserved for select members who demonstrate sustained contributions, industry leadership, and outstanding performance. We will announce the experts being inducted into the Experts Exchange Fellowship during the annual Expert Awards, but unlike other awards, Fellow is a lifelong status. This title may not be given every year if there are no obvious candidates.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.