List Box Command and Filter Criteria

[Londa Sue]

Hello,

I've a list box for which I've multiple filters. I'd like to add another
criterion for one of the filters. Here is the code:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*'))
ORDER BY tbl_main.DocumentID"

Along with '*PL*', I'd like to add '*CMP*' so that it gives me both PL and
CMP records. I tried:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*' AND
'*CMP*')) ORDER BY tbl_main.DocumentID"

but this didn't work.

May I get an edit on this, please?

Thank you,

 

[alex]

Hello,

I've a list box for which I've multiple filters.  I'd like to add another
criterion for one of the filters.  Here is the code:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*'))
ORDER BY tbl_main.DocumentID"

Along with '*PL*', I'd like to add '*CMP*' so that it gives me both PL and
CMP records.  I tried:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*' AND
'*CMP*')) ORDER BY tbl_main.DocumentID"

but this didn't work.

May I get an edit on this, please?

Thank you,

air code...

Will this work:
DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) in
('*PL*','*CMP*')) ORDER BY tbl_main.DocumentID"

 

[Douglas J. Steele]

DocList.RowSource = "SELECT ID, DocumentID, DocumentTitle, ReleaseDate,
Version, Valid FROM tbl_main Where DocumentID Like '*PL*' Or DocumentID
Like '*CMP*' ORDER BY DocumentID"

 

[Guest]

Hello,

I've a list box for which I've multiple filters. I'd like to add another
criterion for one of the filters. Here is the code:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*'))
ORDER BY tbl_main.DocumentID"

Along with '*PL*', I'd like to add '*CMP*' so that it gives me both PL and
CMP records. I tried:

DocList.RowSource = "SELECT tbl_main.ID, tbl_main.DocumentID,
tbl_main.DocumentTitle, tbl_main.ReleaseDate, tbl_main.Version,
tbl_main.Valid FROM tbl_main Where (((tbl_main.DocumentID) Like '*PL*' AND
'*CMP*')) ORDER BY tbl_main.DocumentID"

but this didn't work.

May I get an edit on this, please?

Thank you,