How to expand query

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

Guest

I think I'm probably going to be one of a few people who want to expand my
query based on a result or I need to find a new way to do the query I want.
So I'm fishing for ideas on how to do this. I want to use a query to
generate a report. I have a table that contains Part #s, Quantity, On Order,
Order Point, 3 Location Fields (Cabinet, Shelf, Bin), Check box for Bin
Empty, and Check Box for Ok to Order and a Change ID#. I want to design a
query that would go out and find the parts that are below the order point,
but if there is one below the order point see if there are any more of the
same Part # still out there. Can someone give me an idea to make this work
 
T. Burr said:
I think I'm probably going to be one of a few people who want to expand my
query based on a result or I need to find a new way to do the query I want.
So I'm fishing for ideas on how to do this. I want to use a query to
generate a report. I have a table that contains Part #s, Quantity, On Order,
Order Point, 3 Location Fields (Cabinet, Shelf, Bin), Check box for Bin
Empty, and Check Box for Ok to Order and a Change ID#. I want to design a
query that would go out and find the parts that are below the order point,
but if there is one below the order point see if there are any more of the
same Part # still out there. Can someone give me an idea to make
Click to expand...
this work

T. Burr,

Please provide the DDL (including CONSTRAINTS)
for all of the Tables involved. If the DDL is
not available, please include a well-formatted
text description (monospace-font) of the
structures of each Table, including a
description of the Primary and Foreign Keys
(i.e. "relationships"). Please also include
some sample data from each (enough rows from
each table to allow the Queries shown to be
executed).


Sincerely,

Chris O.
 
I started to write out the information you wanted and realized that I may
need to re-think the way my database is designed. I will start running into a
lot of problems the way that it is now. Thank you for wanting to help, but I
don't want to waste anymore of your time on this before I fix some of the
problems I noticed. Once I finish the redesign I will repost if I need to.
Thanks again.
 
Back
Top