469,347 Members | 22,107 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Broken Query?

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

Aug 30 '06 #1
2 1291
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.
Aug 30 '06 #2
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

Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Danny | last post: by
1 post views Thread by Dmitry Davletbaev | last post: by
2 posts views Thread by dkintheuk | last post: by
6 posts views Thread by Jason Collins | last post: by
4 posts views Thread by D. Shane Fowlkes | last post: by
25 posts views Thread by Norman Diamond | last post: by
8 posts views Thread by punk86 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.