count documents matching case

[greenfields]

I have a table called "day" with a single record for each day.

I have another table called "Mail" containing many records for each day. The two tables are related by date.

There is a field in "Mail" called "temp". This is a dropdown containing HOT, WARM or COLD.

I want to put a field in "day" called "hot" which counts the amount of records in "Mail" where "temp" = HOT.

please help!

[bcooney]

Put a calc field in Day that equals "Hot." Relate Day to Mail by Date and Hot=temp.

Create a calc in Day cntHot = count (HotRelationship::Date)

[comment]

Try:

ValueCount ( FilterValues ( List ( Mail::temp ) ; "HOT" ) )

---

P.S. A single record for each day? Is that really necessary?

[greenfields]

nothaving much joy, could you maybe expand example?

many thanks

[greenfields]

sorted! many thanks