Report gives ID, not company name

[Philip Wanless]

I have a simple table holding a list of legal defence firms that we use at court. Each name has an autonumber ID assigned. When I try to create a report sorted by defence firm, I get the ID number instead of the firm name. This is no good - the report will be summarizing the time it takes to complete cases and the cases have to be sorted by defence firm. HOw do I get around this problem. There are only 2 columns to the table - the ID and the firm name. Can I simply specify which column in the table to use in the report? If so, how.

Any help appreciated

Thanks

Philip

 

[mhartman]

Hello
In the design mode of the report merely check to see what table field your text box is "bound" to. This would be the "Control Source" property of the text box.

Regards
Mark