Sending a report by email for a single/specific record

G

Guest

I am trying to send a report by email. How do I limit this email report to
include information for a single record and not the entire table?
 
A

Al Campagna

NKirkland,
You'll have use that record's key value to filter the query behind the report.
Say you're looking at a specific record on a form (ex. ClientID = 12345) and you would
like to email that info.
Your query behind the report would have a criteria against the ClientID field of...
=Forms!frmYourFormName!ClientID
That will filter the report for just that unique ClientID.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

Emailing each record to different recipient Access 2003 1
Access 2010 Report Button 0
Single Report from teveral tables with a single to many relationsh 1
Query design 0
How many report pages for a single record? 3
email report per record 1
Send a single report 8
Access Automatically Send a notification email once a record is added 0

Top