Hello,
I work in a medical field where patients come for treatment
every week day, for a number of weeks. This is scheduled in
a database. (call this date scheduled_date).
On some treatment dates we have the patients take xrays.
There may be 1, 2 or 3 taken on any particulate treatment
date. Each image taken is time stamped (call this
image_date). Each image is given a unique name (image_name).
I want to be able to create a report where, if the
schedule_date = image_date, then a count will increase by 1,
and then reset for the next day. Essentially, I want to
count the number of images taken on any particular day.
At the moment I have grouped my report, 1st level is the
schedule_date, then the 2nd level is image_date, then the
third is image_name. There is a computed field in the
image_name header that display 1 if the image date and the
schedule date are the same, and 0 if they are not. I
intended to sum the counter for each scheduled date. This is
where I fall into a hole.
I am not very familiar with infomaker, and trying to teach
myself at the same time as writing this report (with little
success).
Any suggestions would be helpful.
Regards
Vincent
|