calculation within a text box

[Swifey]

I am doing a 3 year comparison therefore on my Frontpage Form, I would like to key into a text box the current year/month, then for the 2nd and 3rd year text boxes to automatically calculate a years difference.

For example
Text Box : month = 200402 (Input field)
Text Box : Pend = 200302 (Calculation field)
Text Box : 3end = 200202 (Calculation field)

The Database field name is called Salesperiod, the format: Number: Long Integer, output example 200402. I have tried the subsequent default value formula but I cant get it to work. Could you please help

Text Box Properties: month = current year/month
Input field

Text Box Properties: Pend  = 2nd year/month
Default Value = IIf([month]>0,([month]-100))

Text Box Properties: 3end = 3rd year/month
Default Value = IIf([pend]>0,([pend]-100))

 

[bat17]

I dont see what is wrong. what results are you getting?
I would not use the iif statments just do the calculation and control the value in the first box. You could just set the value of the first box to the current year/month combo and then use validation to make sure that any changes are of an aceptable value.

Peter

 

[Swifey]

I just get blank text boxes.
When I run the 3 queries which look at the three frontpage form text boxes the first query runs which looks at the input field and then returns nothing for the year on year comparison text boxes

Regards

 

[bat17]

one possibility that comes to mind is that it is treating the data as text rather than a number. try setting the field format to "General Number" and see if that helps

Peter

 

[Swifey]

Unfortunatley I cant change the database field formats they are defined/set by our programers.

Cheers

 

[bat17]

you can set the formats in your form, that might sort it out. If not you can use a function to do it in the form. cLng() should do it.

HTH

Peter

 

[Swifey]

Thanks for your help