Access field in Report (1 Viewer)

[Mickster]

Hi there I am trying to display the value of a field on a report. This field exists in a query. This is what I have right now:

=[UnitConcernCount]![Ash 1]

but I keep getting a #NAME whenever I run the report.

Any idea on what I am doing wrong?

Thanks

 

[elbweb]

well obviously, its a name, so first, check the table and the field names, second i would look at the space in the name, try to get rid of spaces, period. so rename whats in the table, and change the code accordingly, if that doesnt work and still giving you the name error, check to see if anything else on the form has a name of that field or table (i.e. a bound text box) because that would interfere as well