Search results

  1. P

    Database Design

    I am making an inventory database which I will have every single item in the database with its own serial number. The items will be shipped out, some will be returning by RMA. Is it better to have all the items in one single table? or have two table , tblItemIn abd tblItemOut.
  2. P

    Alternate to "Not In"

    That is too slow. any alternate ways?
  3. P

    Data sheet not adding new record

    normally, when you type something into a datasheet it would add a new record. how ever I am using a pop-up dialog to input a value in to the datasheet. then the datasheet does not add a new record. how do i make this happen? I don't have any fields to dirty. all the fields are locked so...
    • pat15
    • Thread
    • Replies: 2
    • Forum: Forms
  4. P

    Hate GROUP BY

    I have a Query with three fields StockId Date OrderId I want to Max(Date) and Group StockId and get the OrderId However, it is required to do GROUP BY OrderId in SQL and this will return every record. I just need that OrderId, and this thing won't let me. :mad: By the way, StockIds...
Back
Top Bottom