unique values in reports? i think...

[CHAOSinACT]

ok, got a simple report that does all jobs by job number... if the job description is the same it only lists the first one... why? i didn't tell it to look for unique values or anything....? ideas?

 

[CHAOSinACT]

btw entire sql statement

SELECT tblDGroupCivilMinorJobs.*, tblClients.[Client Name]
FROM tblClients INNER JOIN tblDGroupCivilMinorJobs ON tblClients.ClientID = tblDGroupCivilMinorJobs.[Client ID];