#error in the field of my Report

[calucho]

Hi
I try to do these formula but I never got the rigth value: just the #error in the field that I wnat to put the value.
I use CDbl function and Val function but nithing.

=IIf([Flag]=1,
CInt(Count(

))[/FONT]
[FONT=Calibri]/DLookUp("[1-Accept] )+[/FONT]
[FONT=Calibri]CInt(Count([code]))",[/FONT]
[FONT=Calibri]"Value Query",[/FONT]
[FONT=Calibri]"cdbl([E-Date]) = Cdbl(#7/20/2012#)"),[/FONT]
[FONT=Calibri]CInt(Count([Code]))[/FONT]
[FONT=Calibri]/DLookUp("[6-Accept]) +[/FONT]
[FONT=Calibri]CIntl(count([code]))",[/FONT]
[FONT=Calibri]"Value Query",[/FONT]
[FONT=Calibri]"cdbl([E-Date])) = cdbl(#7/20/2012#)"))[/FONT]
[FONT=Calibri]I don't know what is wrong with that.:banghead:[/FONT]

[FONT=Calibri]Thank you very much for you help[/FONT]
[FONT=Calibri]Calucho[/FONT]

 

[John Big Booty]

The article here should help you resolve this problem.