« I use YM but receive error msg when trying to access messenger help or tutorial. ‘application not found’.?
i am trying to get two combo boxes in microsoft access 2003 to synchronize.? »

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

Let’s say if I have 10 records but would only want to email the 8th record report, what should I do?

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.

This entry was posted on Sunday, December 27th, 2009 at 7:39 am and is filed under access 2003. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

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

  1. expertaziz Says:
    December 27th, 2009 at 12:56 pm

    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.
    References :

Leave a Reply