Increment numbers on a report

[Dave]

I have an accounts database with records on a subform linked to the main form
against the AccountID, I now want to produce a receipt against the latest
record. Have set up the receipts report but need to give it a serial no,
which will run sequentially.Have an unbound field on the report for the
serial no. The payments can be against any AccountID
So if AccountID 1 gets a payment it will be receipt no 1
If AccountID 34 gets a payment it will be receipt no 2 and so on.
Also need to transfer the serial no against each record for tracking purposes.
Any help would appreciated

 

[tina]

well, if you want the serial number stored as hard data in the table record,
then just generate the serial number in the data entry form - not in the
report - and save it to the underlying table. bind the control in the report
to that table field.

hth

 

[Dave]

Thks Tina

well, if you want the serial number stored as hard data in the table record,
then just generate the serial number in the data entry form - not in the
report - and save it to the underlying table. bind the control in the report
to that table field.

hth

 

[tina]

you're welcome

Thks Tina