Plz help me please

Suppose I have a Text field: A and a calculated field: B

If User will enter some Numeric in Field A like: 2(4x3) / 2 

it will return calculation based on symbols used in text in Calculated Field B: 12

Please Help me sir

Hi,

If we add the operational symbol to the filed, it had to be changed to text filed. Thus, we can't do the calculation based on the text filed.

Please try the 2 workarounds:

1. Add the Numeric in different field and calculate between the fields.

2. Create a form, add two Text Box Controls (Named A and B) . Then we can use VBA coding/programing to add a event to calculate some Numeric which you enter in A. It'll show the result in B.

For the further question about the coding/programing, please post the thread in Access Dev forum of MSDN:

http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

Regards,

George Zhao
TechNet Community Support