I have a main form with a subform on it. The subforms columns are Qty , Part # , Description , Unit Price , and Ext Price. I put a text box on my main form named Total. I got the ext price to add up right from multiplying the qty by the unit price, but I cannot figure out how to total up the ext price column from all the rows and have it show in the total text box. I have it set to currency. I tried =Sum , Sum, =SUM but I still cannot get it to put a value in the total text box. I currently have in the totals textbox ....... =Sum[PartsInventoryTable1subform].Form![ExtPrice]. Am I using the right syntax here?
2 2056
I have a main form with a subform on it. The subforms columns are Qty , Part # , Description , Unit Price , and Ext Price. I put a text box on my main form named Total. I got the ext price to add up right from multiplying the qty by the unit price, but I cannot figure out how to total up the ext price column from all the rows and have it show in the total text box. I have it set to currency. I tried =Sum , Sum, =SUM but I still cannot get it to put a value in the total text box. I currently have in the totals textbox ....... =Sum[PartsInventoryTable1subform].Form![ExtPrice]. Am I using the right syntax here?
No that is NOT the correct syntax.
You have to understand that the SUM function is a function. Since it is a function all options that are used in a function need to be enclosed in ().
Example: -
=DSum("ExtPrice","TableName","[OrderID] = SomeNumericValue")
-
Ok I put in =DSum("ExtPrice","PartsInventoryTable1.subform"). That is returning an error in the textbox. What is the somenumeric value and the brackets around the orderid for? I also put that in the control source, is that the right place?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Darren |
last post by:
Hi,
I am trying to write an Aged Debtors report in MSquery, I have created
all of the columns sucessfully, I just need to have totals of each
column at the bottom of the report - how can this be...
|
by: KashMarsh |
last post by:
Trying to show running totals on a report, except it needs to show one
total amount and values being subtracted from it. For example,
the report shows a Total Inventory amount (TotInvAmt). And...
|
by: |
last post by:
I have gotten the following error in trying to get totals to come out on a
footer.
Server Error in '/test' Application....
|
by: mark |
last post by:
im keeping running totals of certain columns in a datagrid, id like to put
these totals in the footer - how do i do this ? or how can i put a label
into the footer ? (im displaying results using...
|
by: Amac |
last post by:
I would like to create a summary report based on a "Type" field in my
table. I would like to create the following report:
Type 1 Total Balance Type 4 Total...
|
by: rdemyan via AccessMonster.com |
last post by:
I have a subform that displays around 10 fields. Most of the values shown
result from some complex calculations. To make it easy, I have stored the
results in a temporary table and then all I...
|
by: =?Utf-8?B?Um9iZXJ0IENoYXBtYW4=?= |
last post by:
Hi, Fairly easy to create one running total for a gridview but what if you
have dozens of them?
I have a gridview that allows bulk editing (all rows at once) and have it
set up so that, on data...
|
by: JJM0926 |
last post by:
I'm trying to create a running totals query in access 97. I have
followed the directions on how to do it from Microsofts website
article id 138911. I took their code they had and replaced it with...
|
by: colin spalding |
last post by:
How do I design a totals query that instead of the following result
YearOfAcc PremiumGBP
2004 9,142,306.95
2004 1,481,153.21
2005 11,981,987.85
2006 20,653,195.20
2006 ...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |