469,575 Members | 1,662 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Group category on report takes a value on the field from the tablethat uses combo box selection from another table

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.
Jun 27 '08 #1
1 1460
I may try to create a report from query instead of table. See how it
works.

Ikuyasu

On May 3, 11:09*pm, ikuy...@gmail.com wrote:
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.
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Intrepid_Yellow | last post: by
1 post views Thread by deshg | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.