I have the following table in part ---
TblClassDate
ClassDateID
CourseID
ClassDate
Classes for courses are held on multiple days. The data for a course in the
table might look like:
ClassDateID CourseID ClassDate
1 45 9/3/04
2 45 9/15/04
3 45 9/30/04
How can I construct a calculated field in a query to give the class number
for each class such as:
ClassDateID CourseID ClassDate ClassNum
1 45 9/3/04 1/3
2 45 9/15/04 2/3
3 45 9/30/04 3/3
Thanks for all help!
Judy