Easy Filter Question... but i've gone brain dead.

[famousb]

I have a query <b>&quot;qbfDenClaim&quot;</b> which feeds one form, and then i want the same query to feed another form that summarizes the information, but i only want the summary to contain records where <b>[Outcome]</b> does NOT equal <b>&quot;ok&quot;</b>.<br><br>for some reason evil beings have invaded my mind and have prevented me from writing this simple expression.<br><br>could someone please point me in the right direction.<br><br>thanks a bunch <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[elizabeth]

I'm not sure what you mean by summarize but maybe both forms should be based on the same query but the second form should be filtered?

 

[famousb]

both forms are fed by the same query, and i was trying to filter the second form, i just couldn't remember how to do it. basically the second form &quot;summarizes&quot; by filtering to records that weren't &quot;ok&quot;, and gives some aggregates and averages of different fields (this part works fine, except for the filter part).<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[elizabeth]

Do you have the filter set in your form's Filter property like<br>Outcome &lt;&gt; 'OK'<br><br>

 

[famousb]

i've been trying:<br>Outcome &lt;&gt; &quot;Ok&quot;<br>[Outcome] &lt;&gt; &quot;Ok&quot;<br>Outcome Not Like &quot;Ok&quot;<br>[Outcome] Not Like &quot;Ok&quot;<br><br>and i've even made sure that Allow Filters is 'Yes'<br><br>I'm sorry, my mind just doesn't want to work on this correctly, too many people are pulling me too many ways today.<br><br>thanks elizabeth for helping me. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[elizabeth]

You normally only need brackets when you use a space between characters in your field name. The like and not like only work with the &quot;*&quot; before and/or after the substring you're searching for. Try writing a query that shows the values in that field, then try getting it to work as a selection criteria. Look at your data to make sure the value is showing up as you expect it to look in the query. Then paste that criteria into your Filter Property. Also when you open that form is the filter On? (Look at the toolbar).<br><br>BTW, a suggestion for data that you want to keep more uniform for this type of thing is a Yes/No field.

 

[famousb]

thanks again elizabeth, <br>I would have used Yes/No, but there are 4 other possibilities if it is wrong.<br><br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>