I would like to add a field to our invoice report that displays the salesperson for that invoice. I've got a good handle on report editing and some limited programming experience.
I need to know what to add to the report code to display the salesperson variable on the invoice.
Any help is appreciated, even if it's just a link to the right documentation on how to find the variable for the salesperson.
You'd need to link the EnteredBy field in the Orders table to the Text1 field in the Lists table where the List is 'Sales People' in the query that is setting the recordsource of the report, and select the Lists.Text2 field in the same query. Then you can use it as the control source of a text box on the report.
Thanks I got it figured out. I skipped the step to convert the initials to a full name, as we prefer the initials. I'm actually surprised how easy it is to add new fields to the invoice.
For anyone else that runs across this post here is what I did: Add a text box to the report (located in the design tab on the ribbon) Then open the properties on the for the text box. In the Control Source box dropdown choose EnteredBy.
How to Add a Salesperson Field to Invoice Report?
Posted - 10/30/2009 : 7:49:27 PM
