Memo text date

[Guest]

I would like to create a memo field. Is there a way to have the computer
insert a date automatically like the example below and some text to follow
would be entered by the user? This field would be an "comments" field that
would be added to every few weeks/days. This is a sample of the data in the
field (this would be based on only 1 report) and there would be many separate
reports to follow.

"5-Jan-2007: complete GRA packet received.
Note: Product registered and marketed in Italy and may be used as a supply
source for other markets in order to maximize use of XXX mfg. capacity.
15-Jan-2007: confirmed w/A. XXXX; report will only be prepared for the
XXXmarket.
16-Jan-2007: requested approved/signed data tables from XXX and XXX.
23-Feb-2007: requested formal written advisement from XXX(specific
requirements, intent of report, etc.)
23-Mar-2007: follow-up with XXX to verify if report is still required.
5-Apr-2007: will continue to f/u for reply from GRA. Report placed on HOLD
status until official notification from GRA to resume report.
18-Apr-2007: Received notification from XXX; report will be required.
Report taken off HOLD status and is currently inprocess.
31-May-2007: report submitted for final review (XXX)
19-June-2007: GRA requested to place the stability report on hold.
25-Jun-2007:
This report was commissioned as a part of the XXX project. The dossiers for
that project, however, will be prepared ussing a different process.

"
Or would I need a seperate date field for each comment? Thanks for any help
you can give.

 

[Guest]

Sheriff,

This should like one of those situations where you need to rethink your
database design. You may need a seperate table for the entries for each data
and the comments. If you will ever need reporting by date, I would strongly
suggest that you create the new table with the date field (set the default to
=Date() for this field) and your meno field. You will also need a field to
link the records in this table to the records in your main table.

 

[Guest]

thanks

Sheriff,

This should like one of those situations where you need to rethink your
database design. You may need a seperate table for the entries for each data
and the comments. If you will ever need reporting by date, I would strongly
suggest that you create the new table with the date field (set the default to
=Date() for this field) and your meno field. You will also need a field to
link the records in this table to the records in your main table.