>>Select course.coursenumb, course.coursename, ; >> table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ; >> table2.g4, table2.g5, table2.wm2, table2.g6, table2.tot2, table2.ltot ; >> from Course ; >> inner join TABLE2 on table2.no = course.no ; >> into cursor csrCourseStats readwrite >> >>Thisform.Grid1.RecordSource = "csrCourseStats" >>>>
>With Thisform.Grid1. > .RecordSource = "csrCourseStats" > With .Column1 > .Width = 200 > .Header1.Caption = "Anything you like" > .Font = "arial" > .FontSize = 12 > ... > EndWith > With .Column2 > .Width = 45 > .Header1.Caption = "yellow bird" > EndWith > ... >EndWith >>