summing on a form

kevcar40

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

Subscribe Reply

1678

Rick Brandt

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

kevcar40

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

Rick Brandt

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

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...

Python

Counting and summing elements in an array? Help!

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...

C / C++

Format to Currency when multiplying/Summing fields

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...

Javascript

Text Field in a Form summing up the Values in a Subform

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...

Microsoft Access / VBA

Summing calculated data in a form

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...

Microsoft Access / VBA

Help Summing Rows and Columns In A Matrix

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...

Python

Summing two textboxes on a form

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! ...

Microsoft Access / VBA

Sum function not summing correctly

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...

Microsoft Access / VBA

Help with summing values on a form

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...

Microsoft Access / VBA

Summing values in a form inc NULL VALUES?

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...

Microsoft Access / VBA

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

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,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

Similar topics