Table Filter Question

A

Anthony

I have a table that has access tasks assigned to it by 1 and 0. I have a
seq. of
1001000000001000111 and I want to filter all to list every record that has
a 1 in the fourth line. I tried using *, for example all I got was
***1************, but that gave me every record. Is there any way to get
this done.

Thanks
 
P

pietlinden

I have a table that has access tasks assigned to it by 1 and 0.  I havea
seq. of
1001000000001000111   and I want to filter all to list every record that has
a 1 in the fourth line.  I tried using *, for example all I got was
***1************, but that gave me every record.  Is there any way to get
this done.  

Thanks
Click to expand...

mid(StrBits,4)=1
 
J

John W. Vinson

I have a table that has access tasks assigned to it by 1 and 0. I have a
seq. of
1001000000001000111 and I want to filter all to list every record that has
a 1 in the fourth line. I tried using *, for example all I got was
***1************, but that gave me every record. Is there any way to get
this done.

Thanks
Click to expand...

* means any string of characters (zero to huge). ? as a wildcard means any
single character. Try

LIKE "???1*"

as a criterion.
 
Top