Hi everyone,
I want to do something which sounds simple but I can't make it work (story of my life with ACCESS). In my database I have individuals participating in a research study. They each have an individual ID number.
Three are 5 relevant fields to what I am trying to do:
Timepoint (T0,T1,T2 or T3)
Group (Any number)
Planned pack date
Planned Recall 1 date
Planned Recall 2 date
I want to manually update the timepoint and group for a number of individuals.
I then want to tell ACCESS that for everyone who has a timepoint of X and a group of Y their planned pack date should be A, their planned recall 1 date should be B and their planned recall 2 date should be C.
I thought I should be able to do this in an update query with parameters on each field. So the user entered the information for all 5 fields and this updated the planned dates. I entered the parameters e.g. [enter the timepoint] into the criteria row for timepoint and group and the update row for the planned dates.
However this doesn't work. Was this the wrong approach?
Thanks in advance for any guidance you can give me.
I want to do something which sounds simple but I can't make it work (story of my life with ACCESS). In my database I have individuals participating in a research study. They each have an individual ID number.
Three are 5 relevant fields to what I am trying to do:
Timepoint (T0,T1,T2 or T3)
Group (Any number)
Planned pack date
Planned Recall 1 date
Planned Recall 2 date
I want to manually update the timepoint and group for a number of individuals.
I then want to tell ACCESS that for everyone who has a timepoint of X and a group of Y their planned pack date should be A, their planned recall 1 date should be B and their planned recall 2 date should be C.
I thought I should be able to do this in an update query with parameters on each field. So the user entered the information for all 5 fields and this updated the planned dates. I entered the parameters e.g. [enter the timepoint] into the criteria row for timepoint and group and the update row for the planned dates.
However this doesn't work. Was this the wrong approach?
Thanks in advance for any guidance you can give me.