Calculated Field in a Report

[RBoshears]

I'm using a calculated field in a report drawing information from a query. The report uses data from 3 queries, and works fine with the previos two. However, I'm getting #name and #error returns when I attempt the following formula for the record source. =IIf([qryGiantEagleReport3.YTD Sharp Volume]>0,"Yes","No"). Basically what I'm doing is using a query to filter for certain records, then I want the report to populate either "yes" or "no" based on the volume field results. Any suggestions?? Thanks.

 

[amigos]

Shouldn't it be
=IIf([qryGiantEagleReport3].[YTD Sharp Volume]>0,"Yes","No") ?

 

[RBoshears]

I had it that way, and I was getting an #error. I have it the same way as my 1st post in another field refrencing the 2nd of the 3 queries, and it works fine. I don't know, that's what has me pulling my hair out.

 

[RBoshears]

actually [qryGiantEagle3]![YTD Sharp Volume] produces the #error, using the "." with or without the inner brackets makes no difference. It is also wanting a parameter value, and I can't figure out what is triggering that.

 

[Joe4]

Try building the statement in a query using the function builder to get the correct syntax, then try copying it over to the Control Source of your report.