S
Stan
Hi. I have a database that keeps patient followup information for outcomes
after treatment for cancer.
One of my tables has multiple rows of data (toxicity followup) per person
for distinct dates (clinic visits). I am trying to build a query in design
view that requests specific followup data for the last followup date only.
The output of this query would therefore be one row per patient with the
selected toxicity data at last followup.
1) I am able to identify the last date of followup by viewing totals and
grouping by "max," but not "last." I don't understand why they would not
return the same value.
2) I can get the last followup date using "max", but i am stuck getting the
associated data for that max date. Is there a way to get data for that last
date in the design view?
One idea i had was to make an intermediary query that sorts these data by
date, and then use the "last" command to get the last row of data, but this
does not return the correct last value.
any help would be greatly appreciated. thanks!!
after treatment for cancer.
One of my tables has multiple rows of data (toxicity followup) per person
for distinct dates (clinic visits). I am trying to build a query in design
view that requests specific followup data for the last followup date only.
The output of this query would therefore be one row per patient with the
selected toxicity data at last followup.
1) I am able to identify the last date of followup by viewing totals and
grouping by "max," but not "last." I don't understand why they would not
return the same value.
2) I can get the last followup date using "max", but i am stuck getting the
associated data for that max date. Is there a way to get data for that last
date in the design view?
One idea i had was to make an intermediary query that sorts these data by
date, and then use the "last" command to get the last row of data, but this
does not return the correct last value.
any help would be greatly appreciated. thanks!!