Search results

  1. R

    Random number generation

    Hi, I am trying to create a query where each entry in my database is assigned a random number between 1 and 4. After this I will use the query to select certain entries with a specific number that fit other criteria that I will enter later. I have tried Group: Int((4-1+1)*Rnd()+1) however this...
  2. R

    Date in previous week

    Hi, I have spent a long time making a query that calculates samples due to be sent out after one month then every two months for two years for a study I am setting up. The query is as follows: FUDueThisWkorEND...
  3. R

    Checklist table

    Hi, I am making a database for a study where different tables will be completed (by filling in forms) at different times in the study for the same participant. I would like to create a checklist table that automatically lets the user know which table they have filled in for each participantID...
Back
Top Bottom