Access 2010 postcode Query

[Keith Hawes]

In Access 2010 I have a table called CUSTOMER which contains a field called PCODE. In PCODE are the full UK postcodes for my customers. I have created a Query and inserted the table CUSTOMER and pulled down the PCODE field. In the criteria I have inserted Left([PCODE],InStr([PCODE]," ")-1) which I thought would return the left part of the postcode up to the space. This is not working as the PCODE column is blank. What am I doing wrong. Can anyone help please.

 

[jdraw]

I'm confused with

In PCODE are the full UK postcodes for my customers.

and

This is not working as the PCODE column is blank.

...

Is PCODE blank, empty, NULL or is it the UK Postal Code?

 

[Cronk]

You don't put this in the criteria, you put it in as a calculated field.

 

[Keith Hawes]

Thank you Cronk and jdraw for the reply. You are right Cronk I have now put the formula in the field and the result is exactly what I wanted. Thank you.