Group category on report takes a value on the field from the table that uses com

[mlordner]

Hi,

I am trying to create a report that takes a value from the field on a
table as a group category. But
The value on the report takes an id number (auto increment, and the
first column) instead of second column.
It is because the table takes a value from another table which takes a
value from another table by a combo box selection.


If I don't group on report, then this problem doesn't occur.


So, there are two tables involved. Table1 just contains two fields:
one is id and the other is year(i.e. 2000,2001...)
and a field on Table2 takes a value from Table1 by combo box.


I try to create a report based on Table1 and group by "year", I get
"1" or "2" instead of "2000" or "2001". "1" or "2" just a first
column.


I try to change the "rowsource" property, but when you group, the
group field doesn't have "rowsource" property.


I will appreciate for some help on this.

 

[Duane Hookom]

If you want the 2000, 2001, or other year to appear in the report, add the
table containing these values to the record source of your report.