I'm using a text box in an Access report footer. I would like it to return a value from a select query I've made. The following is what I'm using in the control source in the text box:
=Nz(DLookUp("[Total Sports Revenue]","Sports Revenue Aggregate Final","Sports = 'CLEVELAND INDIANS'"),0)
I want the function to go into the query called 'Sports Revenue Aggregate Final' where it will look in the column called 'Total Sports Revenue' and return a currency value if it finds 'CLEVELAND INDIANS' in the 'Sports' column. All the text box keeps returning is #ERROR.
Is there something wrong with my syntax? Please help. Thanks so much!