Notes Field -Report

  • Thread starter Thread starter Jyoti
  • Start date Start date
J

Jyoti

I have a Memo field. Users add notes in this field
everyday. Is there a way, when I print report, I can only
print the latest note they added.
 
Only with great difficulty. You should store each day's note in a
separate record in a related table.
 
First, add a new field in the table where Memo field is
f.ex DataProcessing (format date), may be default value
=date(), whatever format
second, I hope that the user enters the note in a specific
form, so for sure after they finish the note they Close,
or, Save or Update (whatever button you have created
there) or you use ON CLOSE event of form

- Add this date field in that form (may be visible or
not, is up to your designing or needs), and in one of
these buttons (close f.ex add a VBA code like Me!
dateprocessing = now()
so everytime they close or save, this field will have the
last update date. For the Report use the specific criteria
and for sure will work, or select the last date and print
by using combo box or by creating a query as record source
of the Report where you define the last date only as
criteria).
Hope this helps,
Marsela
 
Back
Top