How to create a macro in MS Access that will provide a 10% discount

[Lori Phillips]

I need to create a macro in Access that will have a 10% discount and can't figure it out.

[liimra]

Solution/

In the design view of the macro, make sure "Show All Actions" is selected. Then, you choose the setvalue action. 'Item' will be the field which will contain the discounted price and 'expression' will be the field that already contains the price * 0.9. For example, if the field which will contain the price is called "DPrice" and the one which already contains the price is "IPrice", then the Item will be [DPrice] and the expression will be [IPrice]*0.9.

If the field to be updated is the same, then Item would be [FieldName] & Expression would be [FieldName]*0.9.

Regards,
Ali

[Mr Key]

Hi Mr Phillips, If your question has been answered mark it as ANSWERED to help others who are looking for the same solution! Thanks