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
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