How to display record number on a report?

[laxster]

I'd like to display the record numbers and how many total records there are on a certain report. IE 1 of 15, 2 of 15, etc for every record that is displayed on the report. How do I allow this?

 

[SOS]

What record numbers are you talking about?

Certainly not the ones in the form at the bottom of the navigation, because those have nothing to do with the actual records in the table. It is only a numbering of the recordset returned during that form session only and is not necessarily going to be the same number for the same record each time you look at them.

 

[laxster]

Well, basically, what should happen is that someone enters the number of Pallets on an order. When the report is generated, it should print off which number in sequence it is and the total number of pallets.

There's most likely got to be a way of accomplishing this, but my creative thinking skills are juiced out today.

 

[SOS]

So do you have the sequence number in the table? If so you can add that to the report's record source and then bind a text box to it.

 

[laxster]

Well, I have an Autonumber setup now.

One thing I'm wondering is how one goes about telling a record to repeat itself a certain number of times. IE: a person has 5 pallets they'd like to ship out, the record should be duplicated 5 times, with the only difference being the Autonumber incrementally getting larger.

Any thoughts? I'm not quite sure how to do this.

 

[SOS]

So, out of curiosity, why do you have a record for each pallet? What do you use those records for?

 

[laxster]

The records are just for the session to generate a report for printing. They then would all be deleted, as there is no reason to keep this data.