473,413 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,413 software developers and data experts.

summing on a form

Hi
i have loaded the data from the table in to a continuous form
i am trying to sum the occurrence of the status 1 in a textbox
can anyone tell me how to do this please

thanks

kevin

Jan 14 '06 #1
3 1677
kevcar40 wrote:
Hi
i have loaded the data from the table in to a continuous form
i am trying to sum the occurrence of the status 1 in a textbox
can anyone tell me how to do this please


=Sum(IIf([Status]=1,1,0))
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 14 '06 #2
thank you Rick
the code works a treat
however is there anyway is there anyway i can get this to update if the
status changes at the moment i have to reselect the combo box and
option in the list to get the total to update

thanks
kevin

Jan 14 '06 #3
kevcar40 wrote:
thank you Rick
the code works a treat
however is there anyway is there anyway i can get this to update if
the status changes at the moment i have to reselect the combo box and
option in the list to get the total to update

thanks
kevin


In the AfterUpdate of the Status TextBox issue a Requery.

Me!NameOfSumTextBox.Requery

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 14 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Yaroslav Bulatov | last post by:
I made an array of 10 million floats timed how long it takes to sum the elements, here's what I got (millis): gcc -O2: 21 Python with numarray: 104 Python with Numeric: 302...
2
by: SunMan | last post by:
Hello! I am trying to create a program that will ask for a user to enter a series of letters (codes) and then print out a table that shows the codes in decending frequency. Only letters will be...
2
by: Targa | last post by:
<input NAME="TAXRATE" onBlur="this.form.TAX.value = (this.form.TAXRATE.value - 0) * (this.form.ITEM1TOTAL.value - 0) + (this.form.ITEM2TOTAL.value - 0) " Size="4"> In my TAX field I get...
3
by: Kitana907 | last post by:
Hi- I am having issues with adding up fields in a subform. I have a form that has a subform in datasheet mode. It lists titles of books with their correlating units and dollar amount . The...
1
by: aharding | last post by:
Hello! I have successfuly added a calculation field to a query and inserted that field into my form. It works perfectly. I now need to be able to sum fields of that calculated data in a form...
7
by: lethek39 | last post by:
Hey I have been trying to figure out how to sum rows and columns in a matrix square. I also have been trying to get the program to list the numbers of the diagonal in the matrix. So far this is the...
6
by: slinky | last post by:
I have a form called "subCalendar" with two unbound textboxes I simply need to Sum. I used this below, but get an error. I have the textboxes set to general number. Any ideas? Thanks! ...
3
by: kbeana | last post by:
I can't figure this out for the life of me. I have several fields that are set up as currency, and all have a decimal place of 2. I am summing some of them in the report footer, and it will be a...
6
by: sillyr | last post by:
I have a form where I would like to include a text box that shows the sum of values entered into the form. The form collects information about length by having fields with separate centimeter...
3
by: OllyJ | last post by:
Hi guys hope you can help I have a text box for each day of the week in a form and numbers are entered into them (but sometimes they need to be left blank i.e. not 0). I am summing these values...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.