Recent content by rainbowruthm

That works perfectly. THANKS

Thanks, but when I put that in my query, each row still has the same random number. Any other ideas?

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...

OK - I just added "+ 7" every time I had Date() so it was (Date() + 7) and that seems to have worked. Thanks

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...

Thanks - that's worked perfectly

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...