Numbering

[JA]

I have a group query:

SELECT Course.course_code, Course.course_name, Count
(Course.ID) AS CountOfID
FROM Course
GROUP BY Course.course_code, Course.course_name;

Is there any way I can add a numbering field (using the
build wizard or any way)to give numbering to records.

Please advise.

 

[John Vinson]

I have a group query:

SELECT Course.course_code, Course.course_name, Count
(Course.ID) AS CountOfID
FROM Course
GROUP BY Course.course_code, Course.course_name;

Is there any way I can add a numbering field (using the
build wizard or any way)to give numbering to records.

Please advise.

It's very easy on a Report: just put a textbox on the report with a
Control Source of =1, and set its Running Sum property to "Over All".

In a Query it's a bit more work: you'll need to put in a calculated
field

DCount("*", "[your-query-name]", "[course_code] <= " & [course_code] &
" AND [course_name] <= '" & [course_name] & "'")