last memo entry only

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

Greetings NG. I will be creating a report from various
tables. One of the tables has a memo field in it. The
users are able to add notes on a many notes basis to the
one record. When I do the report, I would like to have
only the last entry be brought into the report rather then
all the entries for the one item. The users when making
the entries will not be the same date (possibly month).
The memo part has a ClientCode, DateOfEntry, Topic,
EnteredBy, Note. So, an example would be 10 people with
10 accts entering info on aged invoices over the course of
the month. I would need to do a report showing those 10
accts and the last entry made on each, by the user. As
each of the 10 accts could many months worth of entries
but only the last is needed.
Has anyone ever had to do something like this and how did
you do it? Or if anyone has any ideas of how to do it?
Thanks in advance to those who respond.
*** John
 
You mention 5 field names and then use words like "Accts" and "Invoices" and
"user". Please be more specific so your requirements match your field names.
 
Sorry, I wasn't sure if I was explaining it properly or
not as I was typing it out. So, let me try this again.

I have TableA (table fields at end of posting) which
holds the possible many notes for a topic. But, there
can be many topics located within the table as well as
ClientCode for different clients. When accessing the
info on a form it is filtered by ClientCode and Topic to
show all the Notes for the one client on the one Topic.
Users are using the same form to enter Notes on all
clients regarding multiple topics.

An example would be Aged Invoices as a topic. I could
have ClientA in which I am tracking the Aged Invoices and
using TableA to keep my Notes as I track this topic along
for ClientA. I could make many entries into the Notes.
Others would be doing the same for other clients with
Aged Invoices but on other topics as well (ie, Reviews,
Contracts, etc).

What I would like to do is when I run a report by topic,
it would show all (or just one) the ClientCodes
associated with that topic but limit the report to only
the last entered Note on the topic for the (one or all)
client.

The table holding the Notes has the following fields.
Each Note entry made would be a new record in the table.
TableAID
ClientCode
DateOfEntry
Topic
EnteredBy
Notes

Thanks for responding. I hope this is clearer and you
understand the process. I realize that I've mentioned
seeking to do it for all or one client. I will accept
either way as it is a starting point to complete the
other.
*** John


-----Original Message-----
You mention 5 field names and then use words
Click to expand...
like "Accts" and "Invoices" and
 
I assume your notes are in the detail section of the report and are grouped
by Client and Topic. Add a text box to the detail section of the report:
Name: txtCount
Control Source: =1
Then use code in the On Format event of the Detail Section
Cancel = Me.txtCount > 1
 
Duane, I followed what you mentioned below and gave it a
try but it didn't work. No error messages either. All
the Note entries appear along with a number 1 infront of
each entry.
Any other thoughts?
*** John
 
Back
Top