Calculations in Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I have Totals: [Qty_Shipped]-[Qty_Received] - I am not getting an error the
result is just blank? They both are number fields.

Rick B said:
Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.



Erika said:
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?
Click to expand...
Click to expand...
 
are some null?

You might need....

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



Rick B

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

Rick B said:
Difference: [Qty shipped] - [Qty received]

Assuming those fields are number fields.



Erika said:
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?
Click to expand...
Click to expand...
Click to expand...
 
That will do it - thank you Rick B!

Rick B said:
are some null?

You might need....

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



Rick B

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

Rick B said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top