Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

simple: add record source to report

Status
Not open for further replies.

GueGueBla

Technical User
Nov 18, 2002
15
ZA
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?
 
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?
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top