Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated Criteria (Access 2003)

    In the Query is a calculated field named "Transparency".

    If A = B, I want the Transparency field to say NO, unless the UC has a number one in it.
    I have the calculated field set up for the basic If, but cannot seem to work out the
    second check.

    The record returned as Company 1, 1, and Company 1 should be included as a Yes with
    records three and four.

    Can anyone help me complete the criteria to get the proper resulting set?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated Criteria (Access 2003)

    Does this expression do what you want?

    Transparency: [UC]=1 Or Not ([A]=<!t>[B])

    Set the Format property of this column to Yes/no (you probably won't be able to select it from the list, but you can enter the format yourself).

  3. #3
    Star Lounger
    Join Date
    Apr 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Criteria (Access 2003)

    That worked great! Thanks!

Posting Permissions

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