Increment numbers on a report

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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
 
Thks Tina

tina said:
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
Click to expand...
 
Back
Top