Search results

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: Term: IIf(InStr([ajl_qryTerm.Term]," ")>0,Mid([ajl_qryTerm.Term],InStr([ajl_qryTerm.Term]," ")+1),[ajl_qryTerm.Term])I thought I...