Calculation too complex

Reppers

Registered User.
Local time
Today, 05:38
Joined
Oct 27, 2008
Messages
32
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
 
Try
Expr1: [Forms].[NewYearAdmin].[YearBeg] & "/" & ([Forms].[NewYearAdmin].[YearBeg]+1)


Brian
 
*Bangs head on wall*

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

Users who are viewing this thread

Back
Top Bottom