Recent content by ajl37

All, Thanks for the help. @Brian, Sorry - it looks like I skipped past your first message completely. It does explain exactly why I was seeing what I was explaining. Your latest expressions looks good. I will try it and see what I get. Many Thanks Andrew

Hi JANR, Thanks for the help, but that still gives the number as "text". Currently I have moved the Val() function to another field. It works, but I have two fields with the same info (one as text the other as a number). I now have the values to work with but would much prefer a cleaner way if...

@JANR That sorts out the blanks - Thanks. I still see the numbers as text though :( as they start off that way. Putting Val() around the Right statement takes me back to the problem I was having at the start where Val() did not work round the Mid(). Thanks Andrew Andrew

As does expr: Val(CStr(Right([Term],Len([Term])-5)))

Hi, Interestingly, the following Term: Val(IIf(InStr([ajl_qryTerm.Term]," ")>0,Mid([ajl_qryTerm.Term],InStr([ajl_qryTerm.Term]," ")+1),[ajl_qryTerm.Term])) converts the numbers to numbers but still leaves me with "#Error" for the blanks. Andrew

Hi, Thanks for the help. @JANR The line: expr: Cstr(Right([Term],Len([Term])-5)) nicely converted the "Term 10" to "10" but still as text. I also have the problem of a field with no text returning "#Error". Many Thanks Andrew

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...