I have a customer table, and a Film table. for every customer i have 1 portal with up to 15 rows. Inside the portal i have a field called "need films" and when i click on the email icon it send an email to our art dep, and it puts an "R" in need films. R stands for request. Now not all rows need films, but what i want is to be able to get the total number of "R" per customer and send that number to my home page that displays all my customers. But i can't do it.

Hope my description helps.

thanks in advance :o

Try using the Count function:

Count(FILM::need_films)

This will count the number of rows that have a value in the need_films field. If you have other codes other than "R", this approach won't work.

Edited July 6, 200718 yr by Guest