Report that Prints Last Record

S

ssmbob

When exiting a form I have a macro to Automatically Print a Report ~ I need
to create a report that only prints the last record. I would just use Print
the Form except I Will modify the report to Print the same Field on 50 Labels
~ Once I can get the Report to Only Come up with the Last Record.

Thanks All
 
L

Larry Linson

Define "last".

The WhereCondition of the DoCmd.OpenReport allows you to select a Record or
Records. It is nicely documented in Help in all recent versions of Access,
even the ones where Help in general, leaves something to be desired.

Larry Linson
Microsoft Office Access MVP
 
S

ssmbob

Larry Linson said:
Define "last".

The WhereCondition of the DoCmd.OpenReport allows you to select a Record or
Records. It is nicely documented in Help in all recent versions of Access,
even the ones where Help in general, leaves something to be desired.

Larry Linson
Microsoft Office Access MVP
Click to expand...
 
S

ssmbob

I have figured out how to do what I need in a Query!
I don't know how to close this Discussion Yrt but I will Try.
Thank All
ssmbob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a report from a form for a single record 2
Print two copies of report 2
Combo box that prints report 1
Printing a Specific Record 1
Print Current Form Record Problem ACC2007 2
Listbox prints black 2
Print Report/Subreport single Record 0
Problem with Report and Forms 2

Top