OK, here's the tables:

CREATE TABLE [dbo].[APPLICATIONS](

[APPLICATIONS_ID] [varchar](10) NOT NULL,

[APPL_APPLICANT] [varchar](10) NULL,

[APPL_START_TERM] [varchar](7) NULL,

CONSTRAINT [PK_APPLICATIONS] PRIMARY KEY CLUSTERED

(

[APPLICATIONS_ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS...

Sorry for the delay in responding - it's been crazy.

I need to count not daily events - the number of events that took place on that date. I need...