Extract PostCode

[leebo1973]

Clever, thanks

If i run the query as a Select query it works fine, but whn I try to create a Table I get the subscript error again.

If i just click End it eventually works???

 

[pr2-eugin]

but whn I try to create a Table I get the subscript error again.

Create a table? Explain that part a bit more please !

 

[leebo1973]

i wanted the query to be a Make Table query

 

[pr2-eugin]

i wanted the query to be a Make Table query

I got that, but my question is why? I thought you already has the table all set up, you only wanted the PostCode. Or am I missing something?