Date Count which includes Duplicate records

[Shardool]

Hey this is my First Post!!! Before i begin with my doubt, lemme first thank all those ppl who created this Forum. It has saved my skin, cleared my doubts, taught me a lotta new things... the list goes on and on .... So a big Thank you

Now The Query.. So I have a table named "Dispensary Data" which contains the following columns

ID, DispensedDate, UniqueChildID, CenterID, DispenedItem, Quantity, NextCollectionDate, Comments

So the Columns DispensedDate(DD), UniqueChildID(UCI) and CenterID(CID) have Duplicate values.
First i wanted the "count of duplicate UCI displayed next to the UCI" which was taken care of thanks to u guys.

Now I want a query which would display the following things

DD UCI Count CID

So i used following query
"
SELECT [Dispensary Touchpoint].[Dispensed Date], [Dispensary Touchpoint].[CenterID], [Dispensary Touchpoint].[UniqueChildID], Count (*)
FROM [Dispensary Touchpoint]
GROUP BY [Dispensary Touchpoint].[Dispensed Date], [Dispensary Touchpoint].[CenterID], [Dispensary Touchpoint].[UniqueChildID];
"

But it ask me to input some parameter for DispensedDate and when i enter that the same date appears on all records... Which is not what i want... I want the query to display the dates from the table... The date is the only issue... Rest all columns are sorted :banghead:

Plzzz help

 

[JHB]

You write the table have the coloumn name "DispensedDate", but in the query you write "Dispensed Date"! (You have a space between "Dispensed" and "Date")