Within a query, I need to show postcode characters to the left of the space, bearing in mind that there can be three or four characters, i.e.
HR57 5FG or
and no spaces must be outputted. Any ideas?
Use a combination of the Left function to return X number of characters from the left part of the string and the Instr function to find the first occurence of the space. Subtract 1 from the result of Instr and you have the X.
Thanks for that, but I am getting the message 'Data type mismatch in criteria expression. I replaced your Table1 with my table name and PostalCode with my postcode field name. Was that the right thing to do?