|
| 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
May 19th, 2006, 08:53 PM
posted to microsoft.public.access.forms
|
|||
|
|||
how do I add 2 amounts in a form using Access
I have created a form using a table and then using a query as a subform. What
I need to do is have a text box that will display "Total Payments"in the main part of my form, in my subform I have the payments made, which are listed in rows. but I can not figure out a formula that will give me the sum of the payments. I put in the text box and have tried a few different expressions in the expression builder but nothing is working. Any ideas?? 
|
|
#2
May 19th, 2006, 09:05 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
how do I add 2 amounts in a form using Access
Try using DSum. Look it up in help.
|
|
#3
May 19th, 2006, 10:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
how do I add 2 amounts in a form using Access
Have a look at the orders form and subform in the Northwind database. It
does exactly that. "klhering" wrote: I have created a form using a table and then using a query as a subform. What I need to do is have a text box that will display "Total Payments"in the main part of my form, in my subform I have the payments made, which are listed in rows. but I can not figure out a formula that will give me the sum of the payments. I put in the text box and have tried a few different expressions in the expression builder but nothing is working. Any ideas??
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MDW | Derrick | New Users | 7 | May 15th, 2006 08:59 AM |
| Tell if Form is a Dialog | Alex | Using Forms | 7 | August 30th, 2005 06:22 PM |
| Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
| dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
| Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |
Linear Mode
