Append Query 2

  • Thread starter Thread starter J.A.C.
  • Start date Start date
J

J.A.C.

Here is what the help on Zero Balances states"When you have fields that
contain Null values, you can create an expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
that converts the Null values to zero. You might do this if you want the
records containing Null values to be included in an aggregate (aggregate
function: A function, such as Sum, Count, Avg, or Var, that you use to
calculate totals.) calculation, or if you want to prevent an expression from
resulting in a Null value when a field that's referenced in the expression
contains Null values. Use the Nz function, for example, to convert Null
values to zero:

Nz([Subtotal],0+Nz([Freight],0)"

My question - Where - What Line - on the Query is this information -
Expression placed?

Thanks
 
Nz([Subtotal],0+Nz([Freight],0)
You did not close the first Nz experssion.

Nz([Subtotal],0)+Nz([Freight],0)
 
Okay I will - But where on the query do I put this code ? On the Criteria
Line? In a new Column -? I am lost on the placement.
--
Methals


KARL DEWEY said:
Nz([Subtotal],0+Nz([Freight],0)
Click to expand...
Click to expand...
You did not close the first Nz experssion.

Nz([Subtotal],0)+Nz([Freight],0)

--
KARL DEWEY
Build a little - Test a little


J.A.C. said:
Here is what the help on Zero Balances states"When you have fields that
contain Null values, you can create an expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
that converts the Null values to zero. You might do this if you want the
records containing Null values to be included in an aggregate (aggregate
function: A function, such as Sum, Count, Avg, or Var, that you use to
calculate totals.) calculation, or if you want to prevent an expression from
resulting in a Null value when a field that's referenced in the expression
contains Null values. Use the Nz function, for example, to convert Null
values to zero:

Nz([Subtotal],0+Nz([Freight],0)"

My question - Where - What Line - on the Query is this information -
Expression placed?

Thanks
Click to expand...
Click to expand...
 
New column lik this --
Total Cost: Nz([Subtotal],0)+Nz([Freight],0)

--
KARL DEWEY
Build a little - Test a little


J.A.C. said:
Okay I will - But where on the query do I put this code ? On the Criteria
Line? In a new Column -? I am lost on the placement.
--
Methals


KARL DEWEY said:
Nz([Subtotal],0+Nz([Freight],0)
Click to expand...
You did not close the first Nz experssion.

Nz([Subtotal],0)+Nz([Freight],0)

--
KARL DEWEY
Build a little - Test a little


J.A.C. said:
Here is what the help on Zero Balances states"When you have fields that
contain Null values, you can create an expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
that converts the Null values to zero. You might do this if you want the
records containing Null values to be included in an aggregate (aggregate
function: A function, such as Sum, Count, Avg, or Var, that you use to
calculate totals.) calculation, or if you want to prevent an expression from
resulting in a Null value when a field that's referenced in the expression
contains Null values. Use the Nz function, for example, to convert Null
values to zero:

Nz([Subtotal],0+Nz([Freight],0)"

My question - Where - What Line - on the Query is this information -
Expression placed?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Perfect - Thanks so much - Clarity is everything to a newbie.
--
Methals


KARL DEWEY said:
New column lik this --
Total Cost: Nz([Subtotal],0)+Nz([Freight],0)

--
KARL DEWEY
Build a little - Test a little


J.A.C. said:
Okay I will - But where on the query do I put this code ? On the Criteria
Line? In a new Column -? I am lost on the placement.
--
Methals


KARL DEWEY said:
Nz([Subtotal],0+Nz([Freight],0)
You did not close the first Nz experssion.

Nz([Subtotal],0)+Nz([Freight],0)

--
KARL DEWEY
Build a little - Test a little


:

Here is what the help on Zero Balances states"When you have fields that
contain Null values, you can create an expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
that converts the Null values to zero. You might do this if you want the
records containing Null values to be included in an aggregate (aggregate
function: A function, such as Sum, Count, Avg, or Var, that you use to
calculate totals.) calculation, or if you want to prevent an expression from
resulting in a Null value when a field that's referenced in the expression
contains Null values. Use the Nz function, for example, to convert Null
values to zero:

Nz([Subtotal],0+Nz([Freight],0)"

My question - Where - What Line - on the Query is this information -
Expression placed?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top