I am using the routines the Ron de Bruin has on his website to do an ADO read
of an Access database and return the results to Excel.

This is working great for all the queries I have done, up until now.

I need a new query, but the selction criteria for the record has to match
only part of the field contents, e.g. I want to search for "TST", but the
fields contain "TST Network", "TST DBA Mainframe".

Basically, I need to return all the records that contain "TST" at the
beginning of the field.

Thank's in advance for any help...

--
Cheers...

SELECT Table1.*, IIf(Left([Field2],3)="TST","Yes","No") AS leftValue
FROM Table1
WHERE (((IIf(Left([Field2],3)="TST","Yes","No"))="Yes"));

"Deke" wrote:

> I am using the routines the Ron de Bruin has on his website to do an ADO read
> of an Access database and return the results to Excel.
>
> This is working great for all the queries I have done, up until now.
>
> I need a new query, but the selction criteria for the record has to match
> only part of the field contents, e.g. I want to search for "TST", but the
> fields contain "TST Network", "TST DBA Mainframe".
>
> Basically, I need to return all the records that contain "TST" at the
> beginning of the field.
>
> Thank's in advance for any help...
>
> --
> Cheers...

Use the SQL "like" operator

Tim

"Deke" <(E-Mail Removed)> wrote in message
news:A0666CAD-8259-4D1D-A784-(E-Mail Removed)...
>I am using the routines the Ron de Bruin has on his website to do an ADO
>read
> of an Access database and return the results to Excel.
>
> This is working great for all the queries I have done, up until now.
>
> I need a new query, but the selction criteria for the record has to match
> only part of the field contents, e.g. I want to search for "TST", but the
> fields contain "TST Network", "TST DBA Mainframe".
>
> Basically, I need to return all the records that contain "TST" at the
> beginning of the field.
>
> Thank's in advance for any help...
>
> --
> Cheers...