Search results

  1. W

    Query does not select all information needed

    I have had similar problems like this in the past but the old solutions don't seem to work here. This is an inventory database. I have two tables in this question, tlbIems and tblTransactions. tblItems lists all items in my database, i.e. boxes, bubblewrap etc. tblTransactions records when I...
  2. W

    Nz problem in select query

    I have a problem that involves null values that I do not know how to solve. I have the following tables: tblOrderDetailsKeyItemIdOrder QtyPO#001A204001002B204001003C304001 tblTransactionsKeyTransDateItemIDReceivedPO#0011/1/2014A1040010021/2/2014B2040010031/3/2014A54001 I also have a table...
  3. W

    my query won't select everything I need

    My db tracks consumable supplies for our warehouse. I have seen the light and now calculate qty on hand instead of storing that value in a table. I do the same with outstanding quantities on order. I also have a query that tells me when it is time to order. Or did. For each item I had the...
  4. W

    how do I autopopulate a form field from a table

    Hello everyone, this is my first post here. I am fairly new to Access and it is my only programming experience. I don't know VBA and have used very little SQL. I am in charge of consumable supplies in our warehouse and have built a database to record inventory, create reports for orders etc...
Back
Top Bottom