Hi,
I am trying to write a report that will let me find the last category date & category for each animal in the table where the category date is less than a parameter date. There will be many category dates, some before the parameter date and some after the parameter date. I know how to work out the maximum date for each animal, but not how to work it out where the date has to be less than the parameter date.
I am using CR XI.
Any ideas?
I am trying to write a report that will let me find the last category date & category for each animal in the table where the category date is less than a parameter date. There will be many category dates, some before the parameter date and some after the parameter date. I know how to work out the maximum date for each animal, but not how to work it out where the date has to be less than the parameter date.
I am using CR XI.
Any ideas?