Access 2010 postcode query to return first part of postcode

[Narvic]

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

[orange]

Cross posted: http://www.access-programmers.co.uk/...12#post1300512

[Narvic]

Thank you for your reply Orange, I have solved the problem. I was putting the formula in criteria instead of field. It now works great.