Ok, I have a report in access that I am adding a text field to.

I have a select statement that returns one value.

I want that select statement to put the value into the text box.

I have been going crazy today figuring it out. All I get is #NAME?

Here is what the source is.

= (Select Top 1 NumAdj From TblName) Thats all. Once I get that to return something, Then I can add a where clause.

Thanks.