simple: add record source to report

[GueGueBla]

Hi there, I have mostly used wizards to create my reports. I am now trying to start one from scratch, however I am having difficuly adding a record source to my report. The field list is greyed out so I cannot click it. Additionally, I am trying to pick out a particular record from that report. i.e imagine a table whick had a list of accounts including Sales. Sales would not necessarily have it's own field but would fall under field account names. So in my report I have added a text box that has Sales revenue, I would like to link that specific box to Sales and give out the sales figure. How can I go about this?

 

[GueGueBla]

Well, I have tried to create an expression using:
=[qry Trial Balance Non-Zero Values]![Account Titles]="Sales"
I was hoping that this would pick up the Value for Sales. Is this possible? How should I be approaching this issue?

 

[GueGueBla]

I have tried building a query that does the criteria for me, and then pointing to the one query and field that would have the sales figure I need. I am still getting a "#name" error in the report preview. Help!