Name and Patient number, how to seperate 1

[din2005]

Hi all

I have this table which has the patients name and there number for e.g
Joe Bloggs dv2054
Clark Kent dd2333
how would I in a query retrieve the patient number (dv2054, dd2333), is there a criteria i could use

thanks

 

[PHV]

You may try to play with the InStrRev function (in the query grid):
Patient#: Mid([name field], 1+InStrRev([name field],' '))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JerryKlmns]

If the patient number is has a fixed lenght (say 6)
then try this update querry

Update YourTable Set TheField1=left([TheField],len([TheField])-6), TheField2=right([TheField],6)

where TheField holds the patients name and there number, TheField1 shall hold the name and TheField2 the patient number. Add those last 2 fields to YourTable.