|
| 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
July 14th, 2009, 03:33 PM
posted to microsoft.public.access
|
|||
|
|||
Showing ID field
I have a client table with ID autonumbers and client names (companies). When
running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline 
|
|
#2
July 14th, 2009, 03:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
Hi
Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
|
#3
July 14th, 2009, 04:02 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
Thanks. My report is based on a query where the client name shows -not the
ID-, yet the report shows the ID number... "Wayne-I-M" wrote: Hi Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
|
#4
July 14th, 2009, 04:17 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
You have used a feature (often times called a mis-feature) of lookup field in
a table. What that does is HIDE the real data (the client id) and show you the related data in another table (client name). Unfortunately this causes you a problem when you want to use the lookup field in a report - the report shows the actual stored value (Client ID) instead of the lookup value (ClientName). You need to change the query to include the table (Clients Table) that has the client name in it and then link the fields that have the ClientID in the two tables. Then ClientName can be used from the Clients table. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Caroline wrote: Thanks. My report is based on a query where the client name shows -not the ID-, yet the report shows the ID number... "Wayne-I-M" wrote: Hi Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
|
#5
July 14th, 2009, 04:19 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
I may be wrong but it sounds you are using a lookup field in your table.
If this is the case then you will have the ID shown as that is what you are selecting - even if you don't see it. You need to add the other table to the query - the one that holds the names. After you have added the other table then double click the name field and add it to the query Open the report in design view and add the new field you have just added to the query, then it will work -- Wayne Manchester, England. "Caroline" wrote: Thanks. My report is based on a query where the client name shows -not the ID-, yet the report shows the ID number... "Wayne-I-M" wrote: Hi Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
|
#6
July 14th, 2009, 04:36 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
Yes, this is the case, I do have a look up. However, I only have one table,
with the ID and the client name together. What should I do in this case? Create a new table? Thanks, C "John Spencer" wrote: You have used a feature (often times called a mis-feature) of lookup field in a table. What that does is HIDE the real data (the client id) and show you the related data in another table (client name). Unfortunately this causes you a problem when you want to use the lookup field in a report - the report shows the actual stored value (Client ID) instead of the lookup value (ClientName). You need to change the query to include the table (Clients Table) that has the client name in it and then link the fields that have the ClientID in the two tables. Then ClientName can be used from the Clients table. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Caroline wrote: Thanks. My report is based on a query where the client name shows -not the ID-, yet the report shows the ID number... "Wayne-I-M" wrote: Hi Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
|
#7
July 14th, 2009, 04:41 PM
posted to microsoft.public.access
|
|||
|
|||
|
Showing ID field
Nevermind, got it, Thank you both!!
"John Spencer" wrote: You have used a feature (often times called a mis-feature) of lookup field in a table. What that does is HIDE the real data (the client id) and show you the related data in another table (client name). Unfortunately this causes you a problem when you want to use the lookup field in a report - the report shows the actual stored value (Client ID) instead of the lookup value (ClientName). You need to change the query to include the table (Clients Table) that has the client name in it and then link the fields that have the ClientID in the two tables. Then ClientName can be used from the Clients table. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Caroline wrote: Thanks. My report is based on a query where the client name shows -not the ID-, yet the report shows the ID number... "Wayne-I-M" wrote: Hi Base the report on a query. Include the ID in the report (you could set the visible = No so you don't see it) Change the source of the ID control on the report to the Client Name -- Wayne Manchester, England. "Caroline" wrote: I have a client table with ID autonumbers and client names (companies). When running a report that use the clients names among other fields, the client field shows the ID number and not the client name, which I would like to see instead. The field shows as "Client" in design view and not "ID", so I'm not sure why I see the number in Report view. Can you tell me what to change? Thank you, Caroline
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
