Adding a seriailized no to a report ?

  • Thread starter Thread starter Tony Benham
  • Start date Start date
T

Tony Benham

I'm using Access 2000.
I have a general question on how I might add serialized nos when I create
reports from my database ?. What I currently do is run a query on the
database, and picks up any customer records that have changed in the last
month, and then prints a report listing the required info for each customer.
What I'm trying to do is put a unique serialized no on each customers report
when I create them. For example if the report finds three customer records
that fit my requirments, it will print 1 page for each customer, with the
relevant info in the database for that customer and on each customers report
print say an 8 digit no which will be 00000001, for the first customer,
00000002 for the second customer, and 00000003 for the third customer. Next
time I run the report I will start print 00000004 on the first customers
report, etc This is like putting a PO or invoice number on a form, and
increasing it everytime a new PO or invoice is created.
Regards
TonyB
 
Not sure excatly how to do this, but I have an idea about how to start...

You would need to create a new table that has an serial number field, client
number, date, etc.

In the "OnPage" property of the report you would need to add a record to
that table.

A few problems...

Does the report create the serial number and then post it to the table, or
does the table contain an auto-number field? If the latter, how do we add a
record to the table, have the table create the auto number, then pull it
back over to the report.

Hopefully yhis string of random thoughts will get you on the path. I will
play around if I get time today and see if I can come up with a solution.

Interesting idae, by the way.

Rick B


I'm using Access 2000.
I have a general question on how I might add serialized nos when I create
reports from my database ?. What I currently do is run a query on the
database, and picks up any customer records that have changed in the last
month, and then prints a report listing the required info for each customer.
What I'm trying to do is put a unique serialized no on each customers report
when I create them. For example if the report finds three customer records
that fit my requirments, it will print 1 page for each customer, with the
relevant info in the database for that customer and on each customers report
print say an 8 digit no which will be 00000001, for the first customer,
00000002 for the second customer, and 00000003 for the third customer. Next
time I run the report I will start print 00000004 on the first customers
report, etc This is like putting a PO or invoice number on a form, and
increasing it everytime a new PO or invoice is created.
Regards
TonyB
 
Back
Top