Search results

  1. S

    Avoid creating duplicates of records that are already exist in DB

    Thanks! I made progess, however it only registers & works with the first entry from the spreadsheet and skips the others. The unique info of the quotes are the "Quote Number"s and DB holds up to 5 records for each so the "Line Number" field could be 1 to 5 with the same "Quote Number". The...
  2. S

    Avoid creating duplicates of records that are already exist in DB

    I have inherited an excel spreadsheet that users use to record customer quotes that gets inserted to an access DB table. Multiple quotes generate separate records, one each (max 4 per form) If a user adds extra quotes to a spreadsheet with quotes that have been processed previously & runs the...
Back
Top Bottom