Concatenation

[krymer]

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 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!

 

[Marshall Barton]

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 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.

"GPS: " & GPA & "- Grade: " & Grade