type conversion failure while append query

[durgapur]

hi,


i am trying to round off the value of a text field and then append it to a decimal field, but it's giving type conversion failure, below is the query plz help :-

IIf(Len(CDbl([a.text]))<8 And Mid(CDbl([a.text]),8,1)<>5 Or Mid(CDbl([a.text]),8,1)<1,(Round(CDbl([a.text]),3)),CDbl(Round([a.text],3)+0.001))

[yashgvt]

hi,


i am trying to round off the value of a text field and then append it to a decimal field, but it's giving type conversion failure, below is the query plz help :-

IIf(Len(CDbl([a.text]))<8 And Mid(CDbl([a.text]),8,1)<>5 Or Mid(CDbl([a.text]),8,1)<1,(Round(CDbl([a.text]),3)),CDbl(Round([a.text],3)+0.001))

Hi Durgapur,

Len(CDbl([a.text] : Len() function will be used only with string/varchar datatypes so don't convert text to decimal before checking the length [Same for other functions].

Try this

IIf(Len([a.text])<8 And Mid([a.text],8,1)<>5 Or Mid([a.text],8,1)<1,(Round(CDbl([a.text]),3)),Round(CDbl([a.text]),3)+0.001))

Hope this helps

[pbmods]

Please use CODE tags when posting source code:

[CODE]
Source code goes here.
[/CODE]