By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,644 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,644 IT Pros & 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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.