I have a query that is working (the report gives me the information I need) but it will only display the Department ID (12 etc.).
I have joined the using #2 "Include all records from CourseTaken and only those from Courses where joined fields are equal" as the other two join types do not work with the Courses table in the query.
What am I doing wrong here? I am fairly new to querys and still not sure how to set up more than a simple one.
I have joined the using #2 "Include all records from CourseTaken and only those from Courses where joined fields are equal" as the other two join types do not work with the Courses table in the query.
What am I doing wrong here? I am fairly new to querys and still not sure how to set up more than a simple one.