Main table and 32 Sub tables

[Peter D]

I have a main table and 32 sub tables linked to the main table.

In those 32 tables i store info, one of those infos is :
wether it is oke ( green - i store a number 3- ),
wether it is not oke( - i store a number 2 -),
wether it is alarm - i store a number 1).
I also store the date of entry because on my main form only the latest
entry is shown.

On that main form I would like to see for each ID_main table how many
Red, Yellow and Green entries there are in total over those 32 tables,
for the latest entrys.
Anyone, Anywhere, Anyhow, Anytime, Anything, Anyway TX