Calculation Function In Form

[deepakg27]

Hi Guys,



I was just wondering, whether it is possible to have simple calculation functions available in forms for a cell like in excel.

Lets take an example of Production Database
For example: in Datasheet view like we are feeding number in production table, Like in Excel if required we ca type "=34+54" and get the result as cells value, is it possible to do the same in access in forms, specially under Data Sheet View.

Thanks for your help.
Regards
Deepak Gupta

[Beetle]

You can do this with an unbound text box control, assigning it a Control Source like =[Field1] + [Field2], but unbound controls can be problematic on Data Sheet or Continuous forms. You're better off doing this using a calculated field in a query that is used as the record source of the form.

SELECT Field1, Field2, Field1 + Field2 AS YourTotal FROM YourTable;

[deepakg27]

Dear Beetle,

Thanks for your help, but I feel I was unable to explain my self. I don't want to create extra field. Like in Production database we add daily production for each production line, which is generally single figure (like 56 or 99 etc), but some times it happens that production for the line is more than one figure (Like 56 & 99=56+99=155), now I want to be able to add the two in that particular field itself. Don't want to use calculator to do it and then insert the figure. Neither want to create extra field as you suggested. Want to do it just it takes place in MS EXCEL (=56+99). Is it possible to do in Access or Not. Though I am quiet certain with help of custom function it can be easily achieved atleast for a limited number of calculations.

Hope I have been able to explain my self.
Thanks and Regards
Deepak Gupta

[isladogs]

Use the Eval function in the textbox after update event

=Eval(textboxname)

Or if you want to see the result in a different textbox, use that code as the other textbox control source