3 Replies Latest reply on Oct 11, 2010 2:54 AM by Jozef

    count based on multiple fields / values

    alexandre_1

      Title

      count based on multiple fields / values

      Post

      Hiya,

      I've trying to find the answer on the internet / this forum, but I'm unable to find it. My apologies in advanced if I've not been searching for the right thing or it is overtly obvious:

      I've got two tables.

      Table overview with a field person_id. Table analyses with three fields; person_id, no_analyses, date.

      Now I've set up the relationship between the tables based on person_id and am able to display in the layout of table overview the total number of analyses a person has done by adding a field sum_analyses which is the calculation Count(analyses:no_analyses)

      Now the second thing I would like to show is the number of analyses a person has done within a date range (a year for example or month). Although It doesn't look too complicated I'm unable to do this, as I can't find the right function to do the job (or combination thereof).

      Does someone have a suggestion?