Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Unanswered: Need Help in adding another expression to my database

    http://s22.postimg.org/wcgll3xkd/image.jpg

    [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
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    haven't got a clue
    unless we can see the design of your tables then I doubt I will ever be able to understands what you are trying to do

    how do you know whether someone is a member of staff as opposed to a undergraduate / graduate. I suspect you are using the date of graduation as the way of determining that. but its not a robust way of doing things

    how do you intend to handle the difference between undergraduate and post graduate. and if my last pieces of work in University systems is to be believed how do you handle the situation where a member of staff may also be an undergraduate and or a postgraduate

    even once you have established how someone is a member of staff, then how in your opinion and your data model do you know where a member of staff should be reported in your form/report
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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