Footnotes

[Sundog]

I am creating an Access data entry form to populate a database. Many of the records require source info, like a footnote/endnote in Word.

I plan to have a text field in each record to capture this reference info; some sources may have data there; some may not; and some data may not be entered sequentially (That is, as the user fills in the form, records 2, 9, and 21 may have a "footnote." Later, more data entry is done, and a footnote is added to record 13.)

Is there a way to autonumber these text fields, the way Word does, so insertion between "footnotes" causes a renumbering? The end product of this effort will be a report that looks, to the extent possible, like a Word document, with endnote numbers corresponding to reference numbers for records in the text.

Lastly, would Access 2007 be favored over Access 2003 to accomplish this effort?

Any hints, tips, or pointers welcome.

[HansV]

This is best done in calculated column in a query based on the table or in the control source of a calculated text box on a form/report bound to the table, so that it will be calculated dynamically.

Let's say that the table is named tblData, the text field is named strNotes, and the table has an AutoNumber primary key ID.

In a query based on tblData, add a calculated column

NoteNr: IIf(IsNull([strNotes]),Null,DCount("strNotes","tblData","ID<=" & [ID]))

You can then use the query as record source for a form or report.

If you prefer to use the table itself as record source, you can place a text box on the form or report with control source

=IIf(IsNull([strNotes]),Null,DCount("strNotes","tblData","ID<=" & [ID]))

[Sundog]

Hans, thank you for your detailed reply . That looks like what I need. When I get to actually coding the beast, I may well return for more help; this info is great. (Once I get it to work, what's the address to send you a bottle of my wife's favorite: Pilsner Urquell; or mine, Blue Moon?)

[HansV]

(Once I get it to work, what's the address to send you a bottle of my wife's favorite: Pilsner Urquell; or mine, Blue Moon?)

You can upload it through BTP*

* Beer Transfer Protocol

[Wendell]

Sorry - we have an export embargo on http://www.bluemoonbrewingcompany.com/ BTP from Colorado - you have to join first!

[HansV]

How sad - I have to select a valid state in order to enter - "NL" is not accepted...

[Wendell]

Try CO - you'll be accepted then. It's corporate located in Golden, CO which is just down the mountain from Evergreen. (Sorry about hijacking the thread.)

[Sundog]

(Sorry about hijacking the thread.)

Not to worry, any news about Blue Moon is good news. In fact, I believe I'll have a bottle tonight just to celebrate the hijack.

[Sundog]

And to continue the hijacking, let's all raise a toast to Spenser , who was known to quaff a Blue Moon now and then. So long Robert B. Parker, died January 18 at age 77.