Results 1 to 2 of 2
  1. #1
    kotascye is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2013
    Posts
    1

    Need Help in adding another expression to my database





    [img=http://s8.postimg.org/jgcyn1kv5/image.jpg]

    [img=http://s23.postimg.org/lg42y9mtj/image.jpg]

    im in need of some serious help....ive provided pics to help with the visualizing and all...

    ok as u see in my daily roll call report i have 2 groups..."on program" and "graduates"

    these 2 groups are creating in the query...as u see in the 2nd pic... the expression as followed

    Expr1: IIf([Date Graduated]<Date(),Date(),[Date Graduated])

    next you can see in my 3rd pic the report and the expression that gives the 2 groups there names...it is as followed

    =IIf(IsNull([Date Out]),IIf(IsNull([Date Graduated]),"On Program","Graduates"),"Recent Departures")

    i will clarify that i took out the names in the roll call but both groups are sorted by the date they came in going down the list


    now i need to add another group "Staff Members" to my roll call...what would be best way to do this???

    every way i have tried altering the query expression or the report expression result in a blank roll call....thanks and God Bless!!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    You want "Staff Members" to display in that textbox if what condition is met?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-30-2013, 05:32 AM
  2. Adding a second Database to my exisisting
    By BigMac4 in forum Database Design
    Replies: 2
    Last Post: 08-30-2012, 06:47 AM
  3. Replies: 3
    Last Post: 07-09-2012, 05:59 AM
  4. adding images & documents to database
    By ksosnick in forum Database Design
    Replies: 2
    Last Post: 10-26-2011, 01:48 PM
  5. Adding Hyperlink to database
    By JeffG3209 in forum Access
    Replies: 3
    Last Post: 05-05-2011, 04:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums