One Q about report

[ANSWER]

Is there way so I can get line number in the report. This is how I have
situation.
I have 4 column on the report:
1. No
2. Name and surname
3. Theme
4. Comment

Columns 2, 3, 4 I get from my queries but I need increment line numbers code
so I can put him on the report directly.
Please help me to solve this.

 

[Guest]

Hi,

One possibilty...

http://support.microsoft.com/default.aspx?scid=kb;en-us;233485

This is a MS knowledge base (KB) article that tells how to set up a query
that will produce a running sum. So, if you estbalish a field in one of your
tables and populate every record with the number one in this field, you
should be able to include this KB process in your existing query and get a
running sum (i.e. line count) field as output.

I haven't tried it, but seems like it could work. There may be much simpler
solutions out there, also.

Let me know if you try it and if it works.