I am building a user report that searches for specific clients established within a certain period of time. (e.g. April 1st, 2012, - June 3rd , 2012). To do so, I have created a form that contains two drop downs, generated as two criteria attached to a data field that tracks when clients were established.
Unfortunately, I am not getting the results I expected, the query pulls an entire list of clients every time I search.
If anyone had experienced the same issue, or has any idea what I might be doing wrong, I would highly appreciate the help.
Notes: I have both fields "comparison type" set to Equal, and Group settings to AND.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
GMSadmin
Hi forum users!
I am building a user report that searches for specific clients established within a certain period of time. (e.g. April 1st, 2012, - June 3rd , 2012). To do so, I have created a form that contains two drop downs, generated as two criteria attached to a data field that tracks when clients were established.
Unfortunately, I am not getting the results I expected, the query pulls an entire list of clients every time I search.
If anyone had experienced the same issue, or has any idea what I might be doing wrong, I would highly appreciate the help.
Notes: I have both fields "comparison type" set to Equal, and Group settings to AND.
GMSadmin
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.