By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

Broken Query?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.