report pulling id data not actual data

[Guest]

Hi,

I have a database that records product samples. I created a report that
would show the names of anyone who has checked out a product sample from our
sample room. My problem is that the report is pulling the ID number not the
name of the person checking out the sample. For instance, I have 3 people
taking samples:

1 - Fred
2 - John
3 - Robert

and the report returns the data as "1" instead of "Fred", "2" instead of
"John", etc.

All three of my reports are having this same problem. Can anyone help me?

 

[Guest]

Hi Sarah
I assume that in your MDB you got a table that contain people name.
1. Open the report in design view
2. Check the RecordSource of the report, does it contain the table that list
people name?
3. If not, add the table to the RecordSource, link both tables using the ID
4. Add the [Name] to the RecordSource
5. In the Report, select the text field that suppose to display the [Name]
and select the new field from stage 4
6. If the table that consist the name was connected to the RecordSource of
the report, check stages 4 and 5 if they are done

 

[Guest]

Hi,

Thanks for the quick response! I'm just a newbie at this so I have no idea
how to check my Record Source.

Hi Sarah
I assume that in your MDB you got a table that contain people name.
1. Open the report in design view
2. Check the RecordSource of the report, does it contain the table that list
people name?
3. If not, add the table to the RecordSource, link both tables using the ID
4. Add the [Name] to the RecordSource
5. In the Report, select the text field that suppose to display the [Name]
and select the new field from stage 4
6. If the table that consist the name was connected to the RecordSource of
the report, check stages 4 and 5 if they are done

--
Good Luck
BS"D

Hi,

I have a database that records product samples. I created a report that
would show the names of anyone who has checked out a product sample from our
sample room. My problem is that the report is pulling the ID number not the
name of the person checking out the sample. For instance, I have 3 people
taking samples:

1 - Fred
2 - John
3 - Robert

and the report returns the data as "1" instead of "Fred", "2" instead of
"John", etc.

All three of my reports are having this same problem. Can anyone help me?

 

[Guest]

Hi Sarah, sorry it took me such a long time to answer.
Open the report in design view, press Alt+Enter, the properties box will open.
Click the Top Left side of the report, so the properties of the report will
be displayed.
One of the properties called "Record Source", locate the cursor in it, and
you'll see a button with three dots, click on it to see the record source.

--
Good Luck
BS"D

Hi,

Thanks for the quick response! I'm just a newbie at this so I have no idea
how to check my Record Source.

Hi Sarah
I assume that in your MDB you got a table that contain people name.
1. Open the report in design view
2. Check the RecordSource of the report, does it contain the table that list
people name?
3. If not, add the table to the RecordSource, link both tables using the ID
4. Add the [Name] to the RecordSource
5. In the Report, select the text field that suppose to display the [Name]
and select the new field from stage 4
6. If the table that consist the name was connected to the RecordSource of
the report, check stages 4 and 5 if they are done

--
Good Luck
BS"D

Hi,

I have a database that records product samples. I created a report that
would show the names of anyone who has checked out a product sample from our
sample room. My problem is that the report is pulling the ID number not the
name of the person checking out the sample. For instance, I have 3 people
taking samples:

1 - Fred
2 - John
3 - Robert

and the report returns the data as "1" instead of "Fred", "2" instead of
"John", etc.

All three of my reports are having this same problem. Can anyone help me?