Two queries



I have two tables: Allocated and Product Lot Info

I want an expression called Unallocated to give me either:

- The difference in amount allocated from the Allocated table and the
Product Lot Info table
- If the product from the Product Lot Info table is not allocated (not in
the Allocated table) I want it to display the product quantity from the
Product Lot Info table

How do I set up the query to do this?
.



Relevant Pages

  • Populate a List Box to select a record
    ... I use the same form to display different sets of records from a query that ... I limit or filter for different subsets by using the ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Combo box requery; update underlying table
    ... The display is ... but the value is not retained in the underlying table. ... The form is based on a query. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Creatinig a database to update in alphabetical order
    ... Use a query with the ... appropriate ORDER BY clause to display the data, ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • pivot table not running correctly..
    ... i have pivots table in different Projects which were running correctly, ... suddenly all of them stoped running correctly and display this message ... "The query could not be processed: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)