roattw Posted April 6, 2017 Report Share Posted April 6, 2017 Have a table of data. Need a report or view showing IF field 1 = X, AND field 2 = A or B or C show those entries. So below, if the field Evals = YES AND field Hospital = A, B, C, D, E, E or F - show them to me. But cant get it to show data: Tried it multiple ways, nothing. ;^) Quote Link to comment Share on other sites More sharing options...
0 Mathilda Posted April 10, 2017 Report Share Posted April 10, 2017 On 4/6/2017 at 9:48 PM, roattw said: Have a table of data. Need a report or view showing IF field 1 = X, AND field 2 = A or B or C show those entries. So below, if the field Evals = YES AND field Hospital = A, B, C, D, E, E or F - show them to me. But cant get it to show data: Tried it multiple ways, nothing. ;^) Hi, I use the similar logic in my view, view returns needed records. Perhaps there are no fields which match criteria. I usually filter table in the datasheet to verify that criteria works as expected. Also I see that in description you wrote that you filter records where Eval field=YES, however, according to the screenshot Eval field contains "Telemedicine". I don't know if that is the case, perhaps you just put wrong description. Hope that helps. Quote Link to comment Share on other sites More sharing options...
Question
roattw
Have a table of data. Need a report or view showing IF field 1 = X, AND field 2 = A or B or C show those entries.
So below, if the field Evals = YES AND field Hospital = A, B, C, D, E, E or F - show them to me. But cant get it to show data:
Tried it multiple ways, nothing. ;^)
Link to comment
Share on other sites
1 answer 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.