txtSearchString display table condition 1

[thefroggy]

Hi,

I'm trying to run an SLQ with two conditions in a table form.

The first condition is a normal txtSearchString application, but I would like to only display some of the d
ata. the (simplified) code I'm currently using is the following:

txtSearchString = Me!TxtX.Text

strSQL = "SELECT DISTINCT tlb.ID as ID, tlb.Code as Code FROM tlb "
strSQL = strSQL & "WHERE ((tlb.ID) Like '" & txtSearchString & "*') "
strSQL = strSQL & "ORDER BY lb.ID"


The problem I have is that not all my data have a Code in tbl, I just want to display value selected with the txtSearchString which have a code in tbl.

Can you help me please, hope this is clear enough.

thanks,

Steph

 

[PHV]

strSQL = "SELECT DISTINCT tlb.ID, tlb.Code FROM tlb "
strSQL = strSQL & "WHERE tlb.ID Like '" & txtSearchString & "*' "
strSQL = strSQL & "AND tlb.Code & '' > '' "
strSQL = strSQL & "ORDER BY tlb.ID"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[thefroggy]

Thanks exactly what I was trying to do.

steph