brian.mccreery
New member
- Local time
- Today, 08:46
- Joined
- May 10, 2010
- Messages
- 2
My knowledge of writing VBA code is limited so can someone please help. I realize that a query is of no use here. Database of 300 records which I have been using in excel but want to bring into access.
field "Invested" needs to be updateable from previous record and changing Drawings Field and %age ie. previous "Invested" +new record "Drawings" x "%age"
I need to click a button and update when and if necessary
Form Data1
Fields ID --- Drawings ---- %age------Invested
---------1----- $xx------- 1.0048675---- $xxxxxx
--------2 -----$xxx------ 1.xxxx -----------?
---------3------$x---------1.xxxx----------- ?
---------4------$xxx------ 1.xxxx----------- ?
---------5------$xxxx----- 1.xxxx----------- ?
etc
many thanks in advance
field "Invested" needs to be updateable from previous record and changing Drawings Field and %age ie. previous "Invested" +new record "Drawings" x "%age"
I need to click a button and update when and if necessary
Form Data1
Fields ID --- Drawings ---- %age------Invested
---------1----- $xx------- 1.0048675---- $xxxxxx
--------2 -----$xxx------ 1.xxxx -----------?
---------3------$x---------1.xxxx----------- ?
---------4------$xxx------ 1.xxxx----------- ?
---------5------$xxxx----- 1.xxxx----------- ?
etc
many thanks in advance
Last edited:
