Query for report using combo box column2

[tjones]

I am attempting to make a query to run a report. One of the fields I need information in my report comes from a combo box (column 2). :banghead:
More information: The information is in a 5 part combo which fills to different fields on the form. I need to pull the information from the second column (assigned Number) so I can get a total of just that course.


Control Source =[Combo91].[Column](2) I need to separate per course "510"

in the create query design how do I enter this?

 

[tjones]

Solution Found posting solution just in case someone else runs into to something similar.

After further checking the combo box information is stored into a table named "Courses"

So what I had to do was change from the "510" in the Course Taken table DepartmentID column to "2" which corresponds to "510" in the Courses table and do not make this visible.

Then add from the table "courses" to show just what assigned number I want to show.