J
jesse
I have created a query that pulls up the last date that a
certain procedure has been completed (i.e. mammogram). I
would like to develop a query that would add 365 days to
the last date seen that gives me the date the next
mammogram is due. I have no problems pulling that query
Next Mammogram Date
[last date])+365
it pulls up the next date perfectly.
The problem is i want to run a paramater query at the
beginning of each month to pull up that months mammograms
that are due. It does not work properly. It pulls from
the last seen and not the Next mammogram date. and YES i
do have the criteria under the correct field. Any ideas?
certain procedure has been completed (i.e. mammogram). I
would like to develop a query that would add 365 days to
the last date seen that gives me the date the next
mammogram is due. I have no problems pulling that query
Next Mammogram Date
[last date])+365it pulls up the next date perfectly.
The problem is i want to run a paramater query at the
beginning of each month to pull up that months mammograms
that are due. It does not work properly. It pulls from
the last seen and not the Next mammogram date. and YES i
do have the criteria under the correct field. Any ideas?