Display Last Entry in field footer

[Bongard]

Hi, I have a report based from a query with the following fields.

Loan#
LoanName
Amount
Analyst
TransactionNotes

I have multiple entries within the detail section and I am only going
to display the footer where I have a sum field on the Amount. The
Loan#, Name and Analyst stay the same across all transactions but a new
note is occasionally entered, so sometimes the field is blank.

In my footer I need to display the last entered TransactionNotes. Right
now the control source for my TransactionNotes = [TransactionNotes]
which will return "" if there was no note entered for the last
transaction.

Can anyone suggest a way to get around these blank entries and get the
report to return the last entry made by a user?

Thanks in advance!!
-Brian

 

[John Spencer]

Is TransactionNotes a text field or a memo field?

Can you add a sort on TransactionNotes using the report Sorting and grouping
dialog?

If you have some other means of determining the LAST TransactionNote (a date
field? a sequence number?) then you will have to post that information so
someone can attempt to help you develop a solution.

 

[Bongard]

Sorry about that it is a textbox.
I already have it grouped by loan number, and then by date so that
a transaction that occurs in September will appear above a transaction
that occurs in October. I could then add a third sort if I wanted by
TNotes but that wouldn't override the Note Date and my field would
still come up with a blank value if the note on the last transaction
was blank.
I don't think there would be another field like a sequence number
that would help us determine the last transaction. The Query is pulling
from a table with the detailed info about every transaction. In that
table, the notes field is just left blank if the user chooses not to
enter anything.

Thanks,
Brian

 

[Bongard]

THIS IS THE FIRST PART OF THE LAST POST


Hi, I have a report based from a query with the following fields.

Loan#
LoanName
Amount
Analyst
TransactionNotes


I have multiple entries within the detail section and I am only going
to display the footer where I have a sum field on the Amount. The
Loan#, Name and Analyst stay the same across all transactions but a new

note is occasionally entered, so sometimes the field is blank.


In my footer I need to display the last entered TransactionNotes. Right

now the control source for my TransactionNotes = [TransactionNotes]
which will return "" if there was no note entered for the last
transaction.


Can anyone suggest a way to get around these blank entries and get the
report to return the last entry made by a user?


Thanks in advance!!
-Brian

 

[Guest]

If I understand correctly you want to exclude empty or blank (null?). You can
do this in the query in the criteria line for the TransactionNotes field :
"not isnullTransactionNotes) which will exclude those records without
transactionsnotes. You may also need to enter into the "or" criteria
(immediately below the null entry) the following: not = "" . ( You could
combine these two entries on the same crietera line: not
isnull(TransactionNotes) and not = "" )

I hope this helps (and I understood correctly)

 

[Bongard]

Thanks for your reply Jeff - That does get me the result that I want in
the Transaction notes field, howevever then those transactions are
excluded from the report so that when I total the detail fields in the
field footer, whatever values don't have transaction notes are then
excluded from those totals.

So to try and explain this a little bit better yet--I need a way to
find that last transaction notes entry and have that displayed in the
footer without excluding the transaction amount in the detail because
that screws up the sum for each loan number.

Thanks in advance!
Brian

 

[Bongard]

Thanks for your reply Jeff - That does get me the result that I want in
the Transaction notes field, howevever then those transactions are
excluded from the report so that when I total the detail fields in the
field footer, whatever values don't have transaction notes are then
excluded from those totals.

So to try and explain this a little bit better yet--I need a way to
find that last transaction notes entry and have that displayed in the
footer without excluding the transaction amount in the detail because
that screws up the sum for each loan number.

Thanks in advance!
Brian