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
"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