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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with report using DLookup 4
make page footer invisible 2
receipts with unbound text box gives Enter Parameter Value 2
Mail merge a report from access to e-mail 1
The Object Doesn't contain the Automation object 'securityTicker' 1
Incremental number in receipt (report) 3
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Report linked to subform in a subform 2

Back
Top