Use the Format function in the SQL (RowSource)

Example:
SELECT DateID, Format(MyDate, "mmddyyyy") FROM DateT ORDER BY MyDate;

I am not good with the whole SQL. This is what my current SQL (RowSource) looks like. Would you be able to help me place it correctly?

SELECT tblQCInspections.QCInspectionID, tblQCInspections.PartNoID, First(tblQCInspections.StartDate) AS FirstOfStartDate, tblQCInspections.Status, tblQCInspections.LotNumber
FROM tblQCInspections
GROUP BY tblQCInspections.QCInspectionID, tblQCInspections.PartNoID, tblQCInspections.Status, tblQCInspections.LotNumber
HAVING (((tblQCInspections.Status)="No Orders" Or (tblQCInspections.Status)="All Insp."))
ORDER BY tblQCInspections.PartNoID;

Hi Kevin,

I was able to figure it out with your suggestion. I didn't realize that it was going to create an expression in the query. I then realized I had to add an extra column count and the column width to the properties. Thank you once again.