If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Additon?
Hello, how can I do this? I have 2 fields. I need to have what is inputed in field1 be ADDED to(not replaced) to field2. Also, after the update i need to have field1 empty again. Any ideas?
|
#2
|
|||
|
|||
Additon?
On Tue, 27 Apr 2004 12:31:04 -0700, Thomas
wrote: Hello, how can I do this? I have 2 fields. I need to have what is inputed in field1 be ADDED to(not replaced) to field2. Also, after the update i need to have field1 empty again. Any ideas? Use a Spreadsheet, if this is really what you want to do! This is NOT a "table" operation. What real-life problem are you trying to solve? John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#3
|
|||
|
|||
Additon?
Thomas,
Put the following code in the AfterUpdate event of Field1: Me!Field2 = NZ(Field2,0) + Me!Field1 Me!Field1 = Null -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Thomas" wrote in message ... Hello, how can I do this? I have 2 fields. I need to have what is inputed in field1 be ADDED to(not replaced) to field2. Also, after the update i need to have field1 empty again. Any ideas? |
Thread Tools | |
Display Modes | |
|
|