Calculation

[nigel brown]

I have got it sorted now.

Many thanks for those that replied

Nigel


Hi all

I have a form that displays a value calculated in a query and displayed on the form.

I have put two unbound text boxes on the form, in these boxes I need to calculate 15% and 30% on the value displayed from the query.

Any thoughts please

Regards

Nigel

 

[MStef]

Send a short example of your mdb, (access 2000 or 2002-2003).

 

[vbaInet]

Just as you would use a calculator to calculate percentages, the same rules (i.e. BODMAS - correct bracketting especially) apply in VBA.

15% of [SomeValue] = ([SomeValue] * 15) / 100

You can then set the Format property of the textbox to Percent.

 

[nigel brown]

Send a short example of your mdb, (access 2000 or 2002-2003).

Hi

Attached is a cut down version. On the form, there are two unbound boxes.

Low is 15% of No of Learners
Medium is 30% of No of Learners

Thanks

NigelView attachment Database3.accdb

 

[MStef]

Send it on the forum.

 

[nigel brown]

Send it on the forum.

Where do you mean?