sql statement

I'm trying to figure out an SQL statement to do the following.

Enter a number: 12345

use that number against a table with the following values:

id, date

The id is not unique. So when the number 12345 is entered I want to count the number of entries with 12345 for the id, that have dates in the date field, that from the current date, are less than a year old.

Thanks.

Steve

Newsgroup replies preferred. Remove nospam when replying thru email. Received on Wed Sep 27 2000 - 10:22:48 CDT