Broken Query?

[shanfitzpatrick]

Ach, I'm in a bind...i can't get one of my queries to work properly.
And i'm certain it's because I don't know how to write the expression
correctly...

I am creating a database that enters items into inventory, then takes
them out when I use them as ingredients in other items i will be
entering into inventory, or take them out when I send them off site. I
created one query for "Total Entered into Inventory", one query for
"total used as ingredients", and one query for "total sent off site".
Now I'm trying to create a query that will show "Total On Hand". The
problem is that every time I create an expression from these three
queries, i get an answer of ONLY the items that have been have data for
all three queries. i want the query to display EVERYTHING. Not just
items that have been entered, used AND sent off. How is this done?

ANY help would be greatly appreciated...

befrismf

[salad]

sh*************@gmail.com wrote:

Ach, I'm in a bind...i can't get one of my queries to work properly.
And i'm certain it's because I don't know how to write the expression
correctly...

I am creating a database that enters items into inventory, then takes
them out when I use them as ingredients in other items i will be
entering into inventory, or take them out when I send them off site. I
created one query for "Total Entered into Inventory", one query for
"total used as ingredients", and one query for "total sent off site".
Now I'm trying to create a query that will show "Total On Hand". The
problem is that every time I create an expression from these three
queries, i get an answer of ONLY the items that have been have data for
all three queries. i want the query to display EVERYTHING. Not just
items that have been entered, used AND sent off. How is this done?

ANY help would be greatly appreciated...

befrismf

Open up your query builder. You need to determine the Master table.
There should be relationship lines between all three queries. Dbl-click
on the lines. Select option 2; All records from "master" and all
records that match from "child". If there are no matches from the
child, the column value is Null...so if you are calcing you may need to
use NZ.

[pietlinden]

NOt to worry. This is not an easy thing to do. You might want to have
a look at Allen Browne's answer to this question.
http://www.allenbrowne.com/AppInventory.html