How do I return the last entry in a table for a report

[ljskipper]

I am having trouble returning the last value in a payment table. It either
returns nothing or every transaction.

 

[John Ortt]

Try doing a query based on the max Transaction Date.

If you paste your current SQL I might be able to help more....

 

[ljskipper]

How do I add a time stamp to the query

First you need to know the records in a table are not in any special
order. If you want the last record, you will need to add a time stamp so
there is a guaranteed way of determining what entry was last.

With that you could use a select query to select the latest time.