I may try to create a re****t from query instead of table. See how it
works.
Ikuyasu
On May 3, 11:09=A0pm, ikuy...@[EMAIL PROTECTED]
wrote:
> Hi,
>
> I am trying to create a re****t that takes a value from the field on a
> table as a group category. But
> The value on the re****t 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 re****t, 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 re****t 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.
|
