Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Unanswered: IIf statment for selective report printing

    I only want a certain report to print if one of the fields in that report is equal to three specific values.

    I've come up with something like this:

    IIf(([Product]="1" Or [Product]="2" Or [Product]="3",print,noprint))

    I just don't know where to put this though.. the report is being run from a macro..

    Any help.. am I close?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Where are you going to invoke this macro from? Test your report operation in there ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2003
    Posts
    300
    ahhhh,

    Something like this:

    [PRODUCT]="1" Or [PRODUCT]="2" Or [PRODUCT]="3"

    in the WHERE portion of the macro that calls up the report.

    seemed to have worked!!!

Posting Permissions

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