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
|
|||
|
|||
adding currency in a form
I know this is a silly questions, but I cannot seem to see to add 4 fields in
a form. I tried using the =sum([amount], [amount2],[amount3],[amount4]), but it does not seem to work. Any suggestions? |
#2
|
|||
|
|||
The Sum function is for columns, not rows. If you want to add the values in
a row you need to do something like this =[amount] + [amount2] + [amount3] + [amount4] -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conrad...essjunkie.html "dchristo" wrote in message ... I know this is a silly questions, but I cannot seem to see to add 4 fields in a form. I tried using the =sum([amount], [amount2],[amount3],[amount4]), but it does not seem to work. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
field default value does not refresh when adding record in form | jrbsdad | Using Forms | 0 | March 5th, 2005 12:19 AM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |