Sort Query

[jice89]

I have a table with all distinct IDs but similar class names. I need to build a query that will display each distinct class name. With everything I do, I always get a new record in the query for each ID name. I am assuming this is a relatively simple thing to do and I am just overlooking something. Please Help

Example...
Class ABCD is offered on Monday, Wednesday or Fridays. I have three records in the original table for Class ABCD. For my query, I only want class ABCD to show up once.

[alansidman]

Without knowing all the fields and what you are attempting to do in your query, a simple answer is not possible. It may be that all you have to do is create an aggregate query and group the results on the class name. We need more information. Field names and what are you trying to accomplish.

Alan

[jice89]

In my tblClasses, I have an ID field, className, classTime, and ClassDay. I want to build a form in order to enroll a student in the class. I would like to be able to view the classes in a drop down menu in the form. The reason I have several IDs with the same className is because the classes are offered at different times. I would like the enroll form to offer the choice of className in the drop down box and then based on the class they choose, another drop down box would have the available times to choose to take that class. Is that enough information, or do you need more or different information? Thanks for your help.

[orange]

Just saw your post and would offer the following advice.

I think you need to include the concept of a Class_Session where there could be 1 or more Class_sessions for a given Class. For example, assume a class called Chemistry 101.
It is offered Mon, Wed, Fri
It is also offered Mon Thu Fri
It is available as evening Class Mon and Tues.

Same Class (Subject) different sessions.

Had a similar problem years ago when dealing with presentations. Same presentation, given by different People at different times ( we used the concept of session to resolve the issue).

Good luck