Calculations in Queries

[Guest]

I have 2 tables I am trying to bring together in a query and perform a
calculation but I am not getting the calculation to work.

First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)

In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.

Any idea?

 

[Rick B]

Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.

 

[Guest]

I have Totals: [Qty_Shipped]-[Qty_Received] - I am not getting an error the
result is just blank? They both are number fields.

Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.

I have 2 tables I am trying to bring together in a query and perform a
calculation but I am not getting the calculation to work.

First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)

In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.

Any idea?

 

[Rick B]

are some null?

You might need....

Totals: Nz([Qty_Shipped],0) - Nz([Qty_Received],0)



Rick B

I have Totals: [Qty_Shipped]-[Qty_Received] - I am not getting an error the
result is just blank? They both are number fields.

Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.

I have 2 tables I am trying to bring together in a query and perform a
calculation but I am not getting the calculation to work.

First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)

In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.

Any idea?

 

[Guest]

That will do it - thank you Rick B!

are some null?

You might need....

Totals: Nz([Qty_Shipped],0) - Nz([Qty_Received],0)



Rick B

I have Totals: [Qty_Shipped]-[Qty_Received] - I am not getting an error the
result is just blank? They both are number fields.

Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.



I have 2 tables I am trying to bring together in a query and perform a
calculation but I am not getting the calculation to work.

First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)

In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.

Any idea?