Search results

  1. G

    Initial Database Design Issue...

    Soon, I will be starting an access database to inventory an entire building's IT assets which include computers, monitors, laptops, tablets, servers, switches, taclanes, etc... All of these items have Serial#'s that are.... quasi-unique... We are moving 10,000+ items to a new building soon...
  2. G

    Count/Sum Metadata that exists in the same record

    We have a SharePoint 2010 Issue tracker at work that we pull metrics off of. So we add a record and assign it to a person. Lets say another person ALSO worked on this item, so we MUST give them some credit. So Tech1 has a record of working on an item. Tech2 and Tech3 are placed in the...
  3. G

    Randomize Query

    I have a table with 4 fields. Each field is supposed to be randomized. So i have the following: organizations (50), measures (20), days of month (31*6 to make 186), times of day (200). Each month I want to click a button that creates a table that has 186 records (1, 1, 1, 1, 1, 1, 2, 2...
  4. G

    Randomizing Query for Multiple fields

    I have a need to randomize multiple records against eachother (see below). ONE record should consist of: Random day from 1-32 (each day can only occur 6 times, if possible). Random organization from organization1, organization2...organization200. Random action from action1, action2... action...
Back
Top Bottom