How do i get data into a report without the ID field

[sam49]

Hi
Can someone please help me.
I have created a database in access 2010 and I have made a data input form on the data input form I have a combo box getting data from another table, and I have set it to store the relevant data in my main table, I have also set the main table not to show the first field the ID field and to show the second field and that’s to data I want to see in the table, now this all works ok I can see the data I want to see on the input form and in the main table and not the ID field.



But now the problem when a create a report I and I get the data from the main table and the column with data from the combo box is displayed on the report as the ID number and not the data as I see it on the main table.

So how do I display the data I need and not the ID field, it was easy in the form and table I just set the first column to 0 but how do you do that for a report

[pkstormy]

You could:

1. use a combobox again.
2. use the dlookup command as the control source in an unbound field.
3. Link the relational table into the recordsource of the report

[SteveF]

Hi
Can someone please help me.
I have created a database in access 2010 and I have made a data input form on the data input form I have a combo box getting data from another table, and I have set it to store the relevant data in my main table, I have also set the main table not to show the first field the ID field and to show the second field and that’s to data I want to see in the table, now this all works ok I can see the data I want to see on the input form and in the main table and not the ID field.

But now the problem when a create a report I and I get the data from the main table and the column with data from the combo box is displayed on the report as the ID number and not the data as I see it on the main table.

So how do I display the data I need and not the ID field, it was easy in the form and table I just set the first column to 0 but how do you do that for a report

Instead of directly using the table to feed data to the report, use a Query. Join the main table and the lookup table together by their common field, and drop the description field from the lookup table into the query instead of the code field from the main table.

You'll have to rebuild your report to point to the query and new data field.

Steve