Thanks guys,

As usual it was a lot more simple than I thought.

The following statement achieves exactly what I was after.

SELECT categoryID, COUNT(CategoryID) AS total

FROM entry

GROUP BY categoryID

ORDER BY categoryID ASC

I...

Thanks for the advice,

The API approach is great, I'd have never worked that out. Although, I have managed to achieve what I want by creating a new column in the...

I've managed to do it, by simply creating an extra column in the main entry table called genres, and executing the following module on the form_close event:

Public Sub AddGenres()

Dim refID...

Thanks Andy,

I think the relationship is normalized, the genres are stored as follows:

Main Table:

EntryID Name Address Pcode etc.......

1 Abc ...