I have a report created in access 2007 which displays items in a quotation. The report acts like a continuous form, with each record displaying as a single row- these are my quotation items. What I need is to add a serial number to each row so that it displays like this:
1. Bunk Bed
2. Office Desk
3. Climbing Frame
(the list will range from 1 item to many items)
I can't use the primary keys of the items because they are dynamically added and won't be consecutive. Is there a way to create a variable in VB and run some code "behind the scenes" to generate these numbers?