Count Uses

[Anon]

Hello,
My problem is:
I have a DB (Access) with 2 Tables.
Table 1 contains 2 columns: KategorieIdx and Kategorie.
In Table 2 is also one column named KategorieIdx.
My Question:
Is it possible to create a column in table 1 that dynamicaly shows in every row the counts of matches of KategorieIdx between Table 1 and Table 2.

Thanks for help.

[Anon]

tables aren't "live' like that, so its not going to update it self like that. You would have to update it yourself.

[mikeq]

Hi,

I wouldn't store the value in table1, but it can be worked out dynamically by running this query:

select T1.KategorieIdx, T1.Kategorie, count(T2.KategorieIdx)
from table1 T1, table2 T2
where T1.KategorieIdx = T2.KategorieIdx
group by T1.KategorieIdx, T1.Kategorie

You can expand this further, let's say you only want to see records where there is a count > 2

select T1.KategorieIdx, T1.Kategorie, count(T2.KategorieIdx)
from table1 T1, table2 T2
where T1.KategorieIdx = T2.KategorieIdx
group by T1.KategorieIdx, T1.Kategorie
having count(T2.KategorieIdx) > 2

Hope this helps
Mike

[Anon]

That's it!
Thanks a lot!

Alex