Count or DCount

F

FerryMary

Could someone possibly suggest means to alter this query to produce a per row
count where VesselID,InitiatedDate and JobType are common to row(JobNumber)?
Currently I get only Max results, when I remove "max" I get a count of "1" on
each row.

SELECT Max(tblJob.JobNumber) AS JobNumber,
Format(tblJob.VesselID,"000") &
Format(tblJob.InitiatedDate,"yy") &
Format(tblStatus.JobType) &
Format(Count(InitiatedDate),"0000") AS ReportNo, tblJob.VesselID
FROM tblStatus INNER JOIN tblJob ON tblStatus.StatusID = tblJob.StatusID
GROUP BY tblJob.VesselID, (tblStatus.JobType), Format(tblJob.VesselID,"000")
& Format(tblJob.InitiatedDate,"yy")
ORDER BY Max(tblJob.JobNumber) DESC;


Thank you so much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top