Recent content by rushilc

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

This code gives me the error, "an action query cannot be used as a row source." In your code, the two qryYourQuery is the same correct?

It's for a monthly mailing list, I need to use a select query from the main table and mail people each month. How would you go about making an automated date-stamp onto the table? Thanks!

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

If I do that, what happens if I have a subject that has two questionnaires, one in year 1 and one in year 2? What would be the primary key of this combined table if not subject id?

Thanks! I am going to try that, I looked up some normalization tutorials, and a lot of them were about just getting rid of repetitive data such as gender, however, I am trying to store different information for every year (which are all different tables), is that not an efficient design? Sorry...

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

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