Novice Question. NZ function

[James Bremner]

I am having trouble with adding data from two tables.
The tables in question are a stock in and a stock out table. For
various reasons it is not suitable to join them into one transaction
table. Obviously, what I want to do is subtract the "out" from the
"in" and get a value for how many of each item is in our cupboard. The
problem arises when nothing of particular product has been removed,
meaning there is no entry in the "out" table.
I have tried using the nz function, but that doesnt seem to help when
there is no entry at all.
Any help would be gratefully recieved as my googling hasnt brought me
any aid.

[Terry Kreft]

Join the tables in a query with an outer join (assuming the In items table
is the first listed it would be a left outer join). you will then get a
full record for each item in the In table and where there are no
corresponding records in the Out table you'll get Null values. You can then
use the Nz functiont convert the appropriate Null values to zeros for your
calculation.

--
Terry Kreft
MVP Microsoft Access
"James Bremner" <ja***********@postmaster.co.uk> wrote in message
news:f4**************************@posting.google.c om...

I am having trouble with adding data from two tables.
The tables in question are a stock in and a stock out table. For
various reasons it is not suitable to join them into one transaction
table. Obviously, what I want to do is subtract the "out" from the
"in" and get a value for how many of each item is in our cupboard. The
problem arises when nothing of particular product has been removed,
meaning there is no entry in the "out" table.
I have tried using the nz function, but that doesnt seem to help when
there is no entry at all.
Any help would be gratefully recieved as my googling hasnt brought me
any aid.