Parameter Query

B

Bhagya

Hi,

I have a Contracts Table where ConID is the primary key.
I am using the fields Program name, start date, end date
among a few other fields.

I want to run a parameter query that asks for an end date
and shows how many contracts are there under each program.

My SQL looks like this

SELECT CONTRACT.ConProgramName, Count (*) AS TOTAL,
CONTRACT.ConAwardType, CONTRACT.ConAwardAmt,
CONTRACT.ConPeriodStart, CONTRACT.ConPeriodEnd
FROM CONTRACT
GROUP BY CONTRACT.ConProgramName, CONTRACT.ConAwardType,
CONTRACT.ConAwardAmt, CONTRACT.ConPeriodStart,
CONTRACT.ConPeriodEnd
HAVING (((CONTRACT.ConPeriodEnd)<[ENTER THE ENDING DATE]));

My problem is that the query is not counting the number of
contracts within the program but is showing for instance
Program name total
Skiing 1
Skiing 1


Any help is appreciated
Thanks
Bhagya
 
Top