How to filter reports and send the selected ones for emailing/printing in Access 2003?

Posted Tuesday, September 7, 2010 by admin


Let’s say if I have 10 records but would only want to email the 8th record report, what should I do?
Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • StumbleUpon
  • Reddit
  • Webnews

Posted in Programming & Design

1 Comment on "How to filter reports and send the selected ones for emailing/printing in Access 2003?"

  • expertaziz said on Sep 8th, 2010 at 6:55 AM:

    make a query to get the relevant record say for example :

    SELECT * FROM urTable WHERE LastName =’” & “Arthur ‘”

    If you have Unique Id u can use

    SELECT * FROM urTable WHERE emplId=” & 8

    Note the enclosed before ‘” and ‘” for string expresson for numeric no need as you will see in second example.

    When you are in Print preview send it by mail.

Leave a Comment