Difficulty getting correct data ---Running a Report

[jj1]

I am trying to run a report showing 3 things
Name of employee
Start date of open issue
Days since the issue is open (For calculating days I am using formula =DateDiff("d",[Start Date],Now())
and my query is

SELECT [Form].[Employee Name], Count([Form].[Completed By]) AS [CountOfCompleted By], [Form].[Start Date]
FROM [Form]


WHERE ((([Form].[Close Date]) Is Null))
GROUP BY [Form].[Completed By], [Form].[Start Date]
HAVING ((([Form].[Completed By]) Is Not Null) AND ((Count([Form].[Completed By])) Is Not Null))
ORDER BY [Form].[Completed By];

But my problem is my query gives employees name duplicate times

so my data looks as this
Name Start Date Days issue open
John 2/2/2014 2
John 3/2/2014 4
John 4 /2/2014 6

Where is I want employee name to appear once with maybe total number of days
John 2/2/2014 6

Showing start date is not required in the report.

I tried doing where condition for start date and then query gives me correct data as in
John 2/2/2014 6
However as start date is where doesn't show up on report and thus no calculation days issue open.

[burrina]

Check your query Property Sheet Values.

[June7]

Can't include [Start Date] in the SELECT clause. Or must wrap it into a function such as: Min([Start Date]) As FirstStart

That SQL should error because Employee Name is not in GROUP BY or an aggregate expression. Shouldn't the GROUP BY be grouping on Employee Name instead of Completed By and Start Date?

You have a table named Form? That is not good naming convention.

Also should avoid spaces and special characters/punctuation (underscore is exception) in naming convention.