Search results

  1. J

    Copying certain fields from One group of records to another in same table

    Hi, I have a single table (it's a BOM Requirement table). So I have one column (field) of the table labeled BaseID. I have multiple BaseIDs and and they each have multiple Records. I want to be able to take all the records for a BaseID (say 100 or so) and I want to copy only certain...
  2. J

    Creating new form to add data to an already existant linked table

    I am trying to create a form for a table that is linked to an Excel spreadsheet. The table already has legacy data in it, and my boss wants me to design this form so that rows can be added to this data in Excel. It's in Excel because there are various manipulations they want to do to the data...
  3. J

    Update Query not doing a Find/Replace for me

    Hi, I was wondering why my Update query is saying 0 records will be updated. I started with a Select Query as in Pict1.jpg attached. This returned a couple of hundred records. I converted the query to an Update Query and added a Part_Id in the Update to field so that I can essentially "find...
  4. J

    Get last unique number from a field for each group based on another field and adding

    Hi, I want to create an append query to add a record to our Bills of Material. We have several bills of material that we want to add a part to the bottom of the bill. So basically I am querying a Requirement table that lists all the parts in a BOM by BOM base id... so I have one field which...
Back
Top Bottom