Search results

  1. S

    Randomly returning a percentage of records in a table.

    Good Afternoon, I have a database for asset tracking. We are required to do a 10% random inventory each month so that by the end of the 10th month we have inventoried 100% of all assets. After the 10% inventory is completed the date is entered into the table. I've built a query that will...
  2. S

    Automatically moving records from one table to another in the same database.

    Good Morning, We have a database that tracks personnel with security clearances. There are 3 tables. One for individuals with ACTIVE clearances, one for individuals who are IN PROCESS and one for individuals that have been DEBRIEFED and are no longer cleared. What I want to do is set it up...
Top Bottom