Link to home
Start Free TrialLog in
Avatar of tariqanis
tariqanis

asked on

Inserting a text box in a data report to display a running number

Hi.... Can any one tell me how to make a text box in a data report (not connected to a source) display a running incremental number... all I need is for the box to display the number 1 in the first row and 2 in the second row and 3 for the third row ...etc.. Thanks
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

In order to use the Data Report you will need to "connect" it to your source.  There are several ways to this, but it would depend on your database.  For example, in SQL Server you could use a temporary table with an IDENTITY column.

Give us more details and we can probably elaborate.

Also, please maintain your old open questions:
1 01/25/2004 125 Selecting several rows in combo box  Open Databases
2 02/07/2004 200 Filtering Access records using the filte...  Open Visual Basic

And re-read the EE Guidelines on grading:
What's the right grade to give?
https://www.experts-exchange.com/help.jsp#hi73

For the record:
Questions Asked 19
Questions Open 5
Questions Graded: 12
Questions Deleted: 2
Last 10 Grades Given: C B B B B B A B B B
Avatar of tariqanis
tariqanis

ASKER

Hi acperkins... I use an Access database in my application.. each text box in the report is bound to a field in the used table, however there is one unbound textbox in the report and my question should have really been: Can I use an unbound textbox, and, if so, does the data report designer provide tools to enable an unbound textbox to run an incremental number like 1,2,3,4 ...?

As for my grading, I am not sure what I am doing wrong. I base my grades on the importance I give to my question.. however, I will read the EE guidelines..

And as for the  open questions I was only aware of one (dated 01/25/2004 ) which I felt did not generate a satisfactory answer, and was not sure what to do .... my impression was one should leave the question posted for a possible satisfactory response... if there are deadlines or other rules in this regard please advise  ....






 
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Problem solved, thanks.....