Attempting to nest a formula inside an IIf statement in the Control Source of Textbox

[RunTime91]

Greetings All...

It's been a while since I created in access so please forgive if I'm asking the impossible...

I'm trying to get the following the work in the Control Source Property of a TextBox placed in the Report Footer.

=IIf(([SalePerson]) = "Rick", Avg([Sales]), Null)



The formula doesn't error, but it returns 'Null', which actually is an error as the correct value should be 136.6

What I'm trying to get to work is simply to have a textbox that shows the average sales for Rick.

Can this be done using the Control Source property?

Thanks Everyone...

[June7]

=Avg(IIf(SalePerson = "Rick", Sales, Null))

[RunTime91]

So Glad You're still out there June ~

As you already know... solution worked brilliantly!

Thank You so much for your help!