Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Minnesota
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Variable Name on a Report

    I have a table: tblCampus with a LocalCampus (yes/No) field and a CampusName field. I would like to put a label field on my reports that would print the appropriate CampusName using the LocalCampus yes field.
    Thank you, Pat

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variable Name on a Report

    I'm not sure about what you want but you could use a textbox with control source:
    <pre>=IIf([LocalCampus]=True,[CampusName],"")</pre>

    Hope this help
    Francois

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Variable Name on a Report

    This is confusing. Does tblCampus have multiple records? Can only 1 of these records have the LocalCampus field checked? Is this table local to each user?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    New Lounger
    Join Date
    Feb 2001
    Location
    Minnesota
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variable Name on a Report

    Thanks for your kind help -- I am learning as I go and sometimes my brain is out to lunch. I created a one line sub rpt and it works great.
    Pat

Posting Permissions

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