Search results

Hi! I have 3 "sub" queries (EVENT_TYPE_1, EVENT_TYPE_2, EVENT_TYPE_3) for counting some events by quarters of a year. Each has columns ID, Qtr1, Qtr2, Qtr3, Qtr4. They are joined by ID in query MASTER_SUM: SELECT EVENT_TYPE_1.Qtr1 AS EVENT_TYPE_1_Qtr1, EVENT_TYPE_1.Qtr2 AS EVENT_TYPE_1_Qtr2...

Dear All! I have no idea how to solve one problem in MS Access, that even to me sounds like Lesson nr.1, although I am more or less beginner in MS Access. I am stuck! Any help is much appreciated. I have a table with numerous records (15.000 and it's growing). Each record contains all sorts...