Reports Showing Lookup Cells

[Guest]

I've created a report that needs to show the contents of a lookup cell. How
can I get it to show the text in the lookup cell instead of the ID number the
lookup is connected to?

 

[Guest]

Reference the coloumn number of the lookup cell instead of just the lookup cell

=[LookUpCellName].[Column](1)

 

[Guest]

The cell in the report that has the name [Main Menu].[Line] is the lookup
cell. It gives a drop down menu in the tables that goes to [Line].[Line].
When I tell the report to refrence to =[Main Menu].[Column](4) and run the
report it prompts me to enter something much like a parameter query would
with [Main Menu] being the parameter. When I make the report reference to
=[Line].[Column](1) it prints #Name? on the report where the line name should
be. What am I doing wrong?

Reference the coloumn number of the lookup cell instead of just the lookup cell

=[LookUpCellName].[Column](1)

I've created a report that needs to show the contents of a lookup cell. How
can I get it to show the text in the lookup cell instead of the ID number the
lookup is connected to?