Newbie: Multipling data by a percentage on data entry

[d9085]

Hello...

I am a newbie to Access or any database for that matter. So please be gentle.
I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game.
On my form I have Qty1(for quantity) - Mat1(for Materials) - and Amt1(for the Amount) fields placed from my database.
In Amt1 I would like to typein an amount and have it multiplied by 5% (.05).
I fiddled with the "On Enter" in the Amt1 property box but got nowhere.
Can someone help???

Thanks for your time
d9085@hotmail.com

 

[TheAceMan1]

How are ya d9085 . . .

[blue]I am a newbie to Access . . . [/blue]

[blue]Before you go to far[/blue] or get to deep, be sure you fully understand the following links ([purple]they should bring you up to speed[/purple]) . . .

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

In the meantime, in the [blue]AfterUpdate[/blue] event of [blue]Amt1[/blue], copy/paste the following (be aure to click the 3 elipses

just to the right):

[blue]   Me!Amt1= Me!Amt1 * 0.05[/blue]

See Ya! . . . . . .