how do I list a series of notes, in date order

[Guest]

I need to produce a monthly report where the latest notes are displayed, but
retain the historical data. So far, all I have is a single field for Notes.
How do I expand this to hold the "old" data, add new and then run a report to
show only the latest notes.

thanks in anticipation

Isobel

 

[Nick 'The database Guy']

Hi Isobel,

You need to create an autonumber field, I suggest the name (NoteID)
this creates numbers automatically for each record, a number is never
used twice, and they can never be the same. The field size needs to be
Long Integer and the New Values need to be set to Increment. These are
the default values.

Then report you must sort the notes by NoteID.

Good luck

Nick

 

[Nick 'The database Guy']

In the report you must sort the notes by NoteID.*

Hi Isobel,

You need to create an autonumber field, I suggest the name (NoteID)
this creates numbers automatically for each record, a number is never
used twice, and they can never be the same. The field size needs to be
Long Integer and the New Values need to be set to Increment. These are
the default values.

Then report you must sort the notes by NoteID.

Good luck

Nick

 

[John Vinson]

On Thu, 10 Aug 2006 01:11:02 -0700, Isobel C <Isobel

I need to produce a monthly report where the latest notes are displayed, but
retain the historical data. So far, all I have is a single field for Notes.
How do I expand this to hold the "old" data, add new and then run a report to
show only the latest notes.

thanks in anticipation

Isobel

I have to disagree with Nick about the autonumbers. They'll USUALLY
work, but if you replicate the database they'll become random!

An alternative would be to add a Date/Time type field to the Notes
table, with a default value of Now(). This will automatically fill in
with the exact time that the note was created. You can then use a
Query sorting by the time stamp, and you can use the query's Top
Values property to show (say) only the five most recent notes.

John W. Vinson[MVP]