Quick help with SQL code (syntax)

[zahara666]

I have the following code and don't know how to incorporate the string that I need:

"SELECT ... FROM ... WHERE (((ClientTable.ClientName) Not Like "TEST" ) AND ((Int1Table.Invoiced)=False) AND ((Int1Table.Received) Between #" & [Forms]![InvoiceForm]![FromDate] & "# And #" & [Forms]![InvoiceForm]![ToDate] & "#) AND ((Int1Table.ClientCode)="

The code works fine, except I don't know how to handle the Not Like "TEST" part. Will an & do the trick?

Thanks in advance,
Julie

 

[tomschafer]

You probably want to encase "TEST" in wildcards.....

WHERE (((ClientTable.ClientName) Not Like "*TEST*"

 

[zahara666]

I tried that, but that doesn't work. I have to intergrate the string into the SQL code and the quotes are what is messing it up.

Thanks,
Julie

 

[jhall156]

You can use CHR(34)'s around your string literals JHall