Results 1 to 3 of 3
  1. #1
    krymer is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    9

    Concatenation, nested IIF functions

    Hello,



    I need to concatenate data that I have, the output needs to look like this: GPA:3.7 - Grade: A
    I have created fields in the query based on GPA and Grade, and I am using the expression builder to create this query, however I don't know what expression to use. I also need to use a nested IIF function to display Freshman, Sophomore, Junior, or Senior for my corresponding class codes in the database FR, SO, JR, and SR. Thanks for your help!

  2. #2
    krymer is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    9
    ......I have made some progress however it still isn't correct. I have the following expression entered into the query:

    [Students]![GPA] & "("&[Students]![Grade]&")" and I am getting the following output: 3.2 (A) where as 3.2 is the actual GPA of a record and A is the corresponding grade. I need the actual words GPA: to be displayed before the numerical GPA value is displayed , I then need a dash (-) and the word Grade: with the actual grade letter. Please Help, thanks!

  3. #3
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Have tried something like this?

    "GPA: " & [Students]![GPA] & " - Grade: " & [Students]![Grade]
    Last edited by jya; 10-20-2008 at 03:42 PM. Reason: corrected the expression

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

Similar Threads

  1. Nested Joins
    By zephaneas in forum Programming
    Replies: 0
    Last Post: 11-10-2008, 11:49 AM
  2. Multiple IIF functions possible?
    By Northgate in forum Access
    Replies: 0
    Last Post: 10-08-2008, 01:11 PM
  3. Replies: 0
    Last Post: 05-17-2008, 01:18 AM
  4. Functions in Query Criteria
    By hraup in forum Queries
    Replies: 1
    Last Post: 10-06-2006, 06:41 PM
  5. Nested IIf query will not work
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 06-20-2006, 02:03 PM

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