Hi,
Currently I have the following expression in one of my queries which converts a text field containing "Term 1" etc into just the number "1" but still as text:
I thought I would be able to add the Val() function into this to convert the text "number" into an actual number. But it doesn't seem to work.
Any ideas on why not, or any better was of performing the same task?
Many Thanks
Andrew
Currently I have the following expression in one of my queries which converts a text field containing "Term 1" etc into just the number "1" but still as text:
Code:
Term: IIf(InStr([ajl_qryTerm.Term]," ")>0,Mid([ajl_qryTerm.Term],InStr([ajl_qryTerm.Term]," ")+1),[ajl_qryTerm.Term])
Code:
Term: IIf(InStr([ajl_qryTerm.Term]," ")>0,Val(Mid([ajl_qryTerm.Term],InStr([ajl_qryTerm.Term]," ")+1)),[ajl_qryTerm.Term])
Many Thanks
Andrew