Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Thanked 0 Times in 0 Posts

    email rpt only when populated (2003)

    I have a db that I track different materails by vendor (ie. stone, sand, cement, etc.). I have 18 reports, one for each vendor of each material. I am wanting to email these reports out each week to let the vendors know what is ahead on our schedule for them. What I am wanting to do is only send out a rpt if the specific query attached to that vendors rpt is not null, can someone help me with this? As I have currently, there is a query specific for that vendor for that material and a corrseponding rpt. I am also wondering if there is a better way to have the info setup?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: email rpt only when populated (2003)

    It would be more efficient to have one query that returns the data for all vendors and materials, and one report based on this query. You can filter the report for a specific vendor and material.

    The code in <post#=275460>post 275460</post#> shows how to send filtered reports for one variable (employee name in the example); it can easily be adapted for two variables (vendor and material). You can add a test to see if the filtered query returns records, using the DCount function.

    If you need more help, please provide specific information (what are the names and data types of the fields you want to filter on, for example).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts