S
Stan
I have a database which has two tables of interest. One table
("demographics") contains a single row per patient and the date that therapy
was completed. another table ("followup") contains several rows of followup
data for any given patient, with different information available for each
date of followup.
I want to write a simple query which returns a table that excludes any
followup information within 6 months of completion of therapy. I know that
the expression builder can be used to write something like:
but how can i incorporate the minimum 6 months between therapy completion
and followup date? the alternative is to do check this manually but seems
like unnecessary effort.
thanks for your help...
("demographics") contains a single row per patient and the date that therapy
was completed. another table ("followup") contains several rows of followup
data for any given patient, with different information available for each
date of followup.
I want to write a simple query which returns a table that excludes any
followup information within 6 months of completion of therapy. I know that
the expression builder can be used to write something like:
[demographics]![date_of_completion] in the followup_date field,
but how can i incorporate the minimum 6 months between therapy completion
and followup date? the alternative is to do check this manually but seems
like unnecessary effort.
thanks for your help...