Search results

  1. R

    Date Criteria Query

    I am trying to create a mailing list of patients. Let's say I am creating a mailing list for February. I need the mailing list to consist of people who have had surgery in February from the beginning of the database, and people who have had surgery three months ago, so anyone who had surgery...
  2. R

    Select then Append Query

    I have a form which with the push of a button opens a select query. After I have the select query open, is there a way to make a new table with these records directly from the form. I know I can do this by using a "Make Table" query, but I need to make a new table each time, but Access only...
  3. R

    Adding Record to Multiple Tables

    I have a main table with subject id and other fields. I also have 16 other tables which have questionnaire information at 17 different timepoints. In those tables, the subject id is the only connected field between the main table and 17 different years. When I add a new record (by subject id)...
  4. R

    Complex Database

    I only have a little experience with Access and am developing a new database for a summer project for a hospital There are 5000 patients in the database. They all get a questionnaire every year. So I made one table with some key pieces of information about the patients, and then I made...
Back
Top Bottom