Showing ID field

[Caroline]

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

 

[Wayne-I-M]

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

 

[Caroline]

Thanks. My report is based on a query where the client name shows -not the
ID-, yet the report shows the ID number...

 

[John Spencer]

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

 

[Wayne-I-M]

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

 

[Caroline]

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

 

[Caroline]

Nevermind, got it, Thank you both!!

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