Exclude certain records in query

  • Follow


I have a query that includes a field called PositionTitle. I want the query 
to find all records except for anything in the PositionTitle field that 
begins with L. What would I put in the Criteria field in order to do this?

Thanks,

Chad 


1
Reply CEV 6/19/2007 3:50:37 PM

On Jun 19, 11:50 am, "CEV" <c...@advancebkg.com> wrote:
> I have a query that includes a field called PositionTitle. I want the query
> to find all records except for anything in the PositionTitle field that
> begins with L. What would I put in the Criteria field in order to do this?
>
> Thanks,
>
> Chad

like "L*"

0
Reply Jason 6/19/2007 4:28:59 PM


1 Replies
866 Views

(page loaded in 0.028 seconds)


Reply: