Append Query 2

[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

 

[KARL DEWEY]

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

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

 

[J.A.C.]

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

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

 

[KARL DEWEY]

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

--
KARL DEWEY
Build a little - Test a little

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

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

 

[J.A.C.]

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

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

--
KARL DEWEY
Build a little - Test a little

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

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