Changing a text value in an expr:

[maximus4444]

Hello all,

I'm using M$ Access 2002. I have a query which contains an expr as one of the fields. The expression adds three text fields together to create a salutation. This is the expression:

Expr1: [students].[Fname] & " " & [students].[LNAME] & " " & [students].[gradelvl]

Where all three fields are of the Text data type. I am trying to display the students grades for next year. So if the value of [students].[gradelvl] is "10", it should display "11". If it were a Number data type I think this would be easier for me to figure out.

Any ideas?

Thanks for your help,
cheers maX

 

[ajetrumpet]

Expr1: [students].[Fname] & " " & [students].[LNAME] & " " & [students].[gradelvl]

I am trying to display the students grades for next year. So if the value of [students].[gradelvl] is "10", it should display "11". If it were a Number data type I think this would be easier for me to figure out.

Yes sir, it would, as you could simply write...

Expr1: [students].[Fname] & " " & 
    [students].[LNAME] & " " & ([students].[gradelvl] + 1)

Why is this field a text type? Is it possible to change it?

 

[Bilbo_Baggins_Esq]

It's just a guess, but if somebody wrote this database for broad usage, it could be text format to allow for K and PK.

Just a guess...