Calculation too complex

[Reppers]

I'm sure there is a very simple answer to this which I am missing - I've had a rootle but haven't found anything similar on the forums.

On my form I have a text box called [YearBeg] into which the user enters the year in which the school year begins - ie. "09". From this, in a calculation field in my query, I want to get to "09/10" for entry into a table.

I have tried;

Expr1: [Forms].[NewYearAdmin].[YearBeg]+"/"+([Forms].[NewYearAdmin].[YearBeg]+1)

but it is being returned as too complex. As I say, there's probably a very simple explanation, but I'm just not seeing it today! Any help would be appreciated.

Cheers

 

[Brianwarnock]

Try
Expr1: [Forms].[NewYearAdmin].[YearBeg] & "/" & ([Forms].[NewYearAdmin].[YearBeg]+1)


Brian

 

[Reppers]

*Bangs head on wall*

Cheers Brian, I think it may be time to give up for today!

 

[Brianwarnock]

Happy to save wall

Brian