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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSUM HELP!!! 4
access form 1
updated field 3
Totals on a Report 2
Access, average several fields in one row 3
Insert into clause 6
Update Query question 2
How to save to a specific record? 3

Back
Top