Expression builder leaves me stumped

[DannyJ]

Dear All,

I was wondering if you might honour me with your advice. I have a field for
medical clinics, containing data for Pound Lane and Perrin Road (clinic
locations). Creating a Query in design view I tried to use the expression
builder to create a criteria of "pound lane" not "perrin road" ( I realise I
could have had a simple criterion of pound lane but I was experimenting).
The query did not work either when I typed the information in manually or
using the expression builder. Would someone tell me the correct syntax?

Many thanks for your help.

Yours faithfully,

danny

 

[Guest]

"Select * From MyTable Where [medical clinics] = 'Pound Lane'"

To select all records for Pound Lane clinic

 

[DannyJ]

Wow thanks! More cumbersome than I thought :-(

Danny

"Select * From MyTable Where [medical clinics] = 'Pound Lane'"

To select all records for Pound Lane clinic

Dear All,

I was wondering if you might honour me with your advice. I have a field for
medical clinics, containing data for Pound Lane and Perrin Road (clinic
locations). Creating a Query in design view I tried to use the expression
builder to create a criteria of "pound lane" not "perrin road" ( I realise I
could have had a simple criterion of pound lane but I was experimenting).
The query did not work either when I typed the information in manually or
using the expression builder. Would someone tell me the correct syntax?

Many thanks for your help.

Yours faithfully,

danny

 

[Guest]

any time

Wow thanks! More cumbersome than I thought :-(

Danny

"Select * From MyTable Where [medical clinics] = 'Pound Lane'"

To select all records for Pound Lane clinic

Dear All,

I was wondering if you might honour me with your advice. I have a field for
medical clinics, containing data for Pound Lane and Perrin Road (clinic
locations). Creating a Query in design view I tried to use the expression
builder to create a criteria of "pound lane" not "perrin road" ( I realise I
could have had a simple criterion of pound lane but I was experimenting).
The query did not work either when I typed the information in manually or
using the expression builder. Would someone tell me the correct syntax?

Many thanks for your help.

Yours faithfully,

danny