Search results

Yep, just a typo. We need to know how many students total for all classes are onsite each month. I think this is what you're looking for...: Placements (the table name) PlacementID, StartDate, EndDate, TStudents (TStudents is the total number of students in that placement/class). The table...

Hi everyone! So I need to build a query and based on this data (sample): Class A: 6 students; Starts 9/1, ends 12/15 Class B: 5 students; Starts 9/25, ends 11/15 Class D: 10 students; Starts 10/1, ends 10/31 Class E: 8 students; Starts 11/1, ends 12/5 And I'd like the query to give me the...

Hi everyone, I'm Susana - born & raised in Los Angeles but now living in Hawaii. I haven't used Access in years and I'm slowly re-learning it! :)