Is it possible to see how many records there are in a database using asp.. I have an access database with a field called "MessageID". I have about 50 records in that database. Some of the records have 1 for "MessageID" and the rest have 2 for "MessageID". I want to see how many records there are which has 2 for "MessageID".

does anybody have any idea? it sounds very simple... everything else is working good.. I just cant figure this out. thanks a lot...
renjit