I have a table which has a field called RefNo, which contains an 8 or nine digit number. The 7th digit from the left is always a 0 and I need to replace this with a / for each record
eg 12402702 to become 124027/2
or
135695012 to become 135695/12
any suggestions gratefully recieved

You cannot enter / in a number field. / is text.

Brian

BTW if you wanted to do it in a query and were happy to have a text field then
Left([numberfield],6) & "/" & Mid([numberfield],8)

would do it.

Brian

thanks Brian
just what I wanted - works a treat