If you are using the query grid then in a new Column enter the following in the
"rows" indicated
Field: Instr(1,[Your Table Name].[Your Field Name],"BR",0)
Table: <<<Leave this blank>>>
Criteria: = 0
In an SQL Query (switch the query to SQL view) and add the following to the
WHERE clause.
And Instr(1,[Your Table Name],[Your Field Name],"BR",0) = 0
If you don't have a WHERE clause at the end then enter
WHERE Instr(1,[Your Table Name],[Your Field Name],"BR",0) = 0
The entire query would read something like
SELECT <<List of Fields you want to see>>
FROM [Your Table Name]
WHERE Instr(1,[Your Table Name],[Your Field Name],"BR",0) = 0
ORDER BY <<List of fields you want to order by>>
Thanks John,
Don't mean to sound stupid but could you explain how I am to enter this
information and where. Thanks
John Spencer said:
In Access and Jet you are going to have to use something like the following
with the Instr function doing a binarycompare.
WHERE Instr(1,[YourField],"BR",0) = 0
In the query grid:
Field: IsItThere: Instr(1,[Your Table].[YourField],"BR",0)
Criteria: 0
Thanks for the quick response.
It did not work since it also excluded all Br in the field. I just want
the
BR for example if I have
1. NFP Poss BR Free Water and
2. Br Sa and Gr
I want the results to exclude 1 and show 2.
Thanks
:
Not Like "*" & Chr(66) & Chr(82) & "*"
:
Hi, I have a query where I want to retrieve only records from a Table
where
one of th e Fields in that Table does not contain the two letters BR in
upper
case. I am currently using the criteria Not Like "* BR" but it excludes
both
the upper and lower cases as well. Can anyone please help? Thanks