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.
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.
Comment