Print last entry

[D Mainland]

I print a report based on a query. The query takes data
from two different tables, a customer table and a
transaction table. Is there any way to print the report
for the last transaction without having to enter the
transaction autonumber as a parameter.

 

[Arvin Meyer]

If you have a timestamp, you can write a query using the TOP predicate as
the report's recordsource. You can also use the ID field if it's a
sequential autonumber (aircode):

Select TOP 1 *
From rblWhatever
Order By TimeStampField Desc;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access