Additon?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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?
 
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
(e-mail address removed)
www.pcdatasheet.com



Thomas said:
Hello, how can I do this? I have 2 fields. I need to have what is inputed in
Click to expand...
field1 be ADDED to(not replaced) to field2. Also, after the update i need to
have field1 empty again. Any ideas?
 
Back
Top