hELLO,
I have a text box in my report that have the the below formula that
sum the quantity of shipments not on time. Up to here, everything is
good, but now i try to figure how can I sum
if there is no value?
=Sum([SumOfDifférence de Journée])
Please help!!!
Thank you!
Fred's
4  5439 
By Jet's reckoning, null + null + null doesn't add up to any number. If you
want to show 0 in your report when there aren't any shipments not on time,
use the NZ function. Like this:
sum(nz([SumOfDifférenc e de Journée], 0))
Chris
Microsoft MVP
Fred's wrote:
>hELLO,
I have a text box in my report that have the the below formula that
sum the quantity of shipments not on time. Up to here, everything is
good, but now i try to figure how can I sum
if there is no value?
=Sum([SumOfDifférenc e de Journée])
Please help!!!
Thank you!
Fred's
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200806/1
On Jun 30, 4:15*pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
By Jet's reckoning, null + null + null doesn't add up to any number. *If you
want to show 0 in your report when there aren't any shipments not on time,
use the NZ function. *Like this:
* * sum(nz([SumOfDifférence de Journée], 0))
Chris
Microsoft MVP
Fred's wrote:
hELLO,
I have a text box in my report that have the the below formula that
sum the quantity of shipments not on time. Up to here, everything is
good, but now i try to figure how can I sum
if there is no value?
=Sum([SumOfDifférence de Journée])
Please help!!!
Thank you!
Fred's
--
Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...
Hello,
I need to sum the total of shipment not in time when there is no data.
Maybe I don't understand your question. What does your report show when you
use your original expression, =Sum([SumOfDifférenc e de Journée]) when there's
no data and what does it show when you use the NZ function in your expression,
=sum(nz([SumOfDifférenc e de Journée], 0)) when there's no data? My thinking
is that it should show 0 as the sum when there's no data. Is that not what
you want?
Chris
Microsoft MVP
Fred's wrote:
>On Jun 30, 4:15Â*pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
>By Jet's reckoning, null + null + null doesn't add up to any number. Â*If you
want to show 0 in your report when there aren't any shipments not on time,
[quoted text clipped - 20 lines]
>--
Hello,
I need to sum the total of shipment not in time when there is no data.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200807/1
On Thu, 3 Jul 2008 10:05:59 -0700 (PDT), "Fred's"
<fr************ *@hotmail.comwr ote:
>On Jun 30, 4:15*pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
>By Jet's reckoning, null + null + null doesn't add up to any number. *If you
want to show 0 in your report when there aren't any shipments not on time,
use the NZ function. *Like this:
* * sum(nz([SumOfDifférence de Journée], 0))
Chris
Microsoft MVP
Fred's wrote:
>hELLO,
>I have a text box in my report that have the the below formula that
sum the quantity of shipments not on time. Up to here, everything is
good, but now i try to figure how can I sum
if there is no value?
=Sum([SumOfDifférence de Journée])
>Please help!!!
>Thank you!
Fred's
--
Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...
Hello,
I need to sum the total of shipment not in time when there is no data.
Perhaps there is a small difficulty here with translation. Do you mean
that you need a Count of records for which [SumOfDifference de
Journee] is null? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: G Kannan |
last post by:
Hey all!
I have written a perl script to retrieve information from a HTML Form
and insert the data into an Oracle database table. I am gettting the
the following error message:
"Use of uninitialized value in concatenation (.) at register.pl line
38, <STDIN> line 10."
The PERL code is as follows:
|
by: otto |
last post by:
i need to read a variable in a javascript and translate it to a form in
html
the javascript variable is:
<SCRIPT LANGUAGE='JavaScript'>RF2N('Total');</script>
and i need to put that variable as the value in this line
<input type="hidden" name="AMT" value="**">
|
by: Eric Chang |
last post by:
I was working on this simple form with radio boxes.
And when I click on one of the radio box, it tell me the value is
"undefined"
Why is that ? I did defined the value of each radio box:
<input type=radio name='Usetax' value='basic'
onClick='document.myform.amount.value=document.myform.Usetax.value'>
<input type=radio name='Usetax' value='no'
onClick='document.myform.amount.value=document.myform.Usetax.value'>
<input type=radio...
|
by: cwizard |
last post by:
I'm calling on a function from within this form, and there are values set
but every time it gets called I get slammed with a run time error...
document.frmKitAmount.txtTotalKitValue is null or not an object... the
function is like so:
function calc_total()
{
var x,i,base,margin,total,newmargin,newtotal;
base = document.frmKitAmount.txtTotalKitValue.value;
margin = document.frmKitAmount.margin.value/100;
|
by: dmiller23462 |
last post by:
So here's my problem.....I need to set up different email
distributions based on which option in the following Select form has
been chosen....For instance if "Putaway" is chosen it needs to email
User1@here.whatever and User4@here.whatever but if "Loaded" is chosen
it needs to email User2@here.whatever and User3@here.whatever, etc,
etc...
I'm aware that the only thing that really needs to change is the
"Mail.AddAddress" line (at least...
| | |
by: matthew_carver |
last post by:
Hello,
I have an ASP page that loops through a SQL Server 2000 table, then
downloads an Excel sheet the users can save, etc. Works fine, except, I
see that in one particular "comments" field the Excel sheet returns a
#VALUE! error in the cell when there is a large amount of text. I've
looked through the MSKB, MSDN and many ng posts to see if there is a
workaround or solution to this, including looking at the xlWorksheet
properties. Is...
|
by: dbuchanan |
last post by:
Hello,
Here is the error message;
----------------------------
Exception Message:
ForeignKeyConstraint Lkp_tbl040Cmpt_lkp302SensorType requires the child
key values (5) to exist in the parent table.
----------------------------
|
by: tania |
last post by:
i have this table in my database:
CREATE TABLE FILM(
F_ID INT(5) NOT NULL AUTO_INCREMENT,
F_TITLE VARCHAR(40) NOT NULL,
DIRECTOR_FNAME VARCHAR(20) NOT NULL,
DIRECTOR_LNAME VARCHAR(20) NOT NULL,
TYPE VARCHAR(30) NOT NULL,
DURATION TIME ,
YEAR_RELEASE YEAR NOT NULL,
DESCRIPTION TEXT,
|
by: cbellew |
last post by:
Hi guys,
I have a problem with an option group and a two corresponding text boxes. When the user chooses an option value i want the text boxes to populate with text dependent on the choice made.
I have written an AfterUpdate procedure on the frame to try and assign the text to the value of the text box, but for some reason it does nothing...
Here is the code:
Private Sub Frame0_AfterUpdate()
If Frame0.Value = 1 Then
|
by: Astley Le Jasper |
last post by:
Sorry for the numpty question ...
How do you find the reference name of an object?
So if i have this
bob = modulename.objectname()
how do i find that the name is 'bob'
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
