Record Count

[Silvinho]

Ive created a messageborard with a MS Access table called Subject and a Table called messages. Ive created a Query that counts the number of messages per subject:

SELECT DISTINCTROW messages.SubjectID, Count(*) AS [Count]
FROM messages
GROUP BY messages.SubjectID;

How do i link this to the subjects page to give the total number of posts per subject. All that happens is the recordset just gives the first number in the list. i need to link the SubjectID somehow.

can anyone help?

 

[bdfigler]

Try:

If rs holds your recordset object then:

rs.MoveLast
rs.RecordCount