Filtering a Query

[Rob Marr]

Hi.

I am running a query of database which holds information on patients from different PCTs (Primary Care Trusts). I have a field which lists with PCT each patient is from, eg Camden, Barnet.

I need to be able to filter my query so that I only get patients from, for example, Camden, or Barnet.

I think I need to insert a short piece of code into the criteria part of the PCT field in the query. Something that says, only display record if it = Camden.

Can anyone help please?

Thank you,

Rob

 

[stopher]

Assuming you are using the query designer then just put "camden" in the criteria row for the relevant field.

hth
Chris

 

[DCrake]

Are you using actual PCT codes or descriptions?

 

[Rob Marr]

Super, thanks, didn't realise it was quite so easy.
I'm using PCT names, not codes.
Thanks for your help,
Rob

 

[DCrake]

Don't know if you are aware but you can download a list of all PCT names and codes from this Link

David