How to expand query

From: T. Burr (TBurr_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 14:17:01 -0800

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

Relevant Pages

  • Re: Update Query only works first time
    ... Parts and Supplies is not a query it is the table in which the Bin Locations ... Microsoft Access MVP 2006 ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... query, but will have no effect on your original data. ...
    (microsoft.public.access.queries)
  • Re: Adding more fields
    ... I click the tables folder to expand it. ... I click the table products folder so that all the fields appear in the ... Now I have this on the form in design view inside the text box. ... If it's a query, open it in design ...
    (microsoft.public.access.forms)
  • Re: Update Query only works first time
    ... I will assume you have an autonumber field in your Parts and Supplies table that I will refer to as PartID. ... Rather than making 6 Bin fields in that table, what you should do is set up another table for Bins ... Microsoft Access MVP 2006 ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... >query, but will have no effect on your original data. ... No need to apologize for lack of knowledge - we ...
    (microsoft.public.access.queries)