Thank you very much for your reply. It was so fast!
The database was purchased with the fields already set up with the address in one field.
The data has already been imported (there are about 10,000 records)
The data in this particular field is laid out exactly as 1234/100 Smith street.
I need 3 new fields to work out and display:
*unit number is to the left of the forward slash
*street number is to the right of the forward slash
*street name is to the right of the first space.
*ignore any other spaces. (or make it a forth field being street type- not necessary though)
Apologies if I am still unclear, I am not sure how else to explain it but will keep at it if I am making sense at all.