If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
In a Report, how do I display the text not the ID value?
I am trying to generate a report from table#1 that looks up organization
names from table#2. When I include the organization field from table#1 in my report, the report displays the numerical value stored in table #1 not the actual text of the organization name stored in table#2. How do I get the report to display the text value from table #2? I'm just getting started with access and tried finding this in a book I have and on the help topics but to no avail. Any help would be greatly appreciated. Thanks. |
#3
|
|||
|
|||
In a Report, how do I display the text not the ID value?
Rob T wrote:
I am trying to generate a report from table#1 that looks up organization names from table#2. When I include the organization field from table#1 in my report, the report displays the numerical value stored in table #1 not the actual text of the organization name stored in table#2. How do I get the report to display the text value from table #2? I'm just getting started with access and tried finding this in a book I have and on the help topics but to no avail. Any help would be greatly appreciated. Thanks. You need to mak sure you have a proper relationship set up between the two tables and I suggest setting up a query including both related tables and use that as your record source. -- Joseph Meehan Dia 's Muire duit |
#4
|
|||
|
|||
In a Report, how do I display the text not the ID value?
For the report's RecordSource use a query which joins the two tables on the
numerical ID number fields, and which includes the organization name from table#2 as a column in the query's output. You can then bind a control in the report to the organization name column rather than the ID number. Ken Sheridan Stafford, England "Rob T" wrote: I am trying to generate a report from table#1 that looks up organization names from table#2. When I include the organization field from table#1 in my report, the report displays the numerical value stored in table #1 not the actual text of the organization name stored in table#2. How do I get the report to display the text value from table #2? I'm just getting started with access and tried finding this in a book I have and on the help topics but to no avail. Any help would be greatly appreciated. Thanks. |
#5
|
|||
|
|||
In a Report, how do I display the text not the ID value?
Thanks for everyone's help. I did a query and it worked.
"Rob T" wrote: I am trying to generate a report from table#1 that looks up organization names from table#2. When I include the organization field from table#1 in my report, the report displays the numerical value stored in table #1 not the actual text of the organization name stored in table#2. How do I get the report to display the text value from table #2? I'm just getting started with access and tried finding this in a book I have and on the help topics but to no avail. Any help would be greatly appreciated. Thanks. |
Thread Tools | |
Display Modes | |
|
|